O'Reilly logo

DB2 by Pav Kumar-Chatterjee, Matthias Nicola

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13. Defining and Using XML Indexes

This chapter looks at defining and using XML indexes to improve performance. The main reasons why you want to define indexes on XML data are the same as for relational data; that is, to evaluate predicates efficiently and to avoid table scans. Just like you define relational indexes on selected columns of a relational table, you define XML indexes on selected elements and attributes within a single XML column of a table. In particular, XML indexes in DB2 do not automatically index all the values in an XML column, but only the ones that you choose. Although you can choose to index all elements and attributes, you should typically index just those elements and attributes that are frequently used ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required