Reason to index XML data type column

          

Reason to index XML data type column

<<Previous   Next>>

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.  

<<Previous   Next>>
 



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring