XML performance

The following topics include performance tuning considerations that you can follow when working with the pureXML® feature.

The pureXML feature and data organization schemes
Using the pureXML feature with data organization schemes such as database partitioning environments, table partitioning, and multidimensional clustering, can significantly improve query performance and reduce the overhead of data maintenance operations such as reorganization, insertion, and deletion.
Example using XQuery transform in a partitioned database environment
The XQuery transform expression is supported in a partitioned database environment and can be used in scenarios that use extract, transform, and load (ETL) operations.
Using declared temporary tables with XML data
Declared global temporary tables can be useful when implementing solutions that require the creation of non-persistent tables. For example, an application can create a declared temporary table to process intermediate results. When the application session ends, the temporary table is dropped.
Using optimization guidelines with XML data and XQuery expressions
Db2® optimization guidelines used in optimization profiles support XML data. You can create profiles that use guidelines to control the method of moving XML data in a partitioned database environment, the order of joins on XML data types, and the use of user-defined indexes over XML data
Preference of DMS table spaces for pureXML data store performance
For performance-sensitive applications, particularly those involving extensive INSERT activity, it is strongly recommended that you use database managed space (DMS) table spaces.

Related information

15 best practices for pureXML performance in Db2