Gosh folks... based on the low number of responses on this thead, either not a whole lot of people are using the HierarchyID or not a whole lot of people are having problems with its performance.
Maybe I should change the question a bit... are any of you using the HierarchyID data type?
--Jeff Moden
Change is inevitable... Change for the better is not.