I am reading the SQL server 2008 bible and it says the materialized path pattern is significantly faster then the hierarchyid. Is this really true? How can I make the hierarchyid have equal or better performance. ...
I have a tree structure in a table and it uses materialized paths to allow me to find children quickly. However, I also need to sort the results depth-first, as one would expect with threaded forum replies. id | parent_id | matpath | created ----+-----------+---------+---------------------------- 2 | 1 | 1...
Browsing through examples all over the web, I can see that people generate the path using something like "parent_id.node_id". Examples:- uid | name | tree_id -------------------- 1 | Ali | 1. 2 | Abu | 2. 3 | Ita | 1.3. 4 | Ira | 1.3. 5 | Yui | 1.3.4 But as explained in this question - http://stackoverflow.com...