The PATH index builds a B+-tree on (path, value) pair of each XML node in document order over all XML instances in the column.
The PROPERTY index creates a B+-tree clustered on the (PK, path, value) pair within each XML instance, where PK is the primary key of the base table.
Finally, the VALUE index creates a B+-tree on (value, path) pair of each node in document order across all XML instances in the XML column.
No comments:
Post a Comment