Reason to index XML data type
column - March 14, 2009 at 15:50 PM by Amit Satpute
Explain the reason to index XML data type column
Index building avoids parsing the whole data at run time and benefits index
lookups for efficient query processing.
XML indexes can be created on xml data type columns. They index all tags, values
and paths over the XML instances in the column and benefit query performance.
Application can benefit from an XML index in the following situations:
-
When queries on XML columns are a common workload.
-
When XML index maintenance cost during data modification must be considered.
-
When XML values are relatively large and the retrieved parts are relatively
small.
|