Scenario

The health care provider finds that reports to extract information from the PMD documents takes longer than usual.

Operation

XML indexes is demonstrated over here.

Solution

The DBA of the health care provider, get to know that the growing volume of data (business requirement : 9 months of data to be preserved in the base table) resulted in degradation of performance. He creates partition level indexes (Indexes local to the ranges of data) to improve the performance of the queries.

Advantages of having a partition level indexes