Search SSWUG.ORG:



DATABASES

The Performance of Traversing a SQL Hierarchy This is an off-site link.  Please review our Terms of Service for additional information.


(Dwain Camps) It is well known, and blogged to death, that the way to traverse a hierarchy that is stored in a T-SQL table as an adjacency list, is to use a recursive Common Table Expression (rCTE). But what if there was a faster way of traversing an adjacency list? Would you use it?

Read this article..







comments powered by Disqus