Excellent method of placing an index on a UDF.
However the 32 level limit of UDF's is annoying when we have a recursive relationship.
I have recently been looking at the nested set model and this seems to have a lot to offer if the recursive level goes beyond 32.
Takes a little bit of thought though 🙂
cheers
martin