Materialized path pattern VS Hierarchyid

Posted by Luke101 on Stack Overflow See other posts from Stack Overflow or by Luke101
Published on 2010-04-22T23:36:56Z Indexed on 2010/04/22 23:43 UTC
Read the original article Hit count: 1096

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.

© Stack Overflow or respective owner

Related posts about materialized-path-pattern

Related posts about hierarchyid