Summary: Converting a Table to a Hierarchical Structure

The hierarchyid data type can store a hierarchical relationship in a simple, compact format. Proper indexes can efficiently return data by the level of the hierarchy, by sub-trees of the hierarchy, or by traditional singleton lookups.

In this lesson, you used two of the hierarchical methods. The next lesson will demonstrate how to use more of these methods to query and manipulate the hierarchical data.

Community Additions