Articles & Content

Archives

Getting Started with XML Indexing in DB2 9 (H10)

Topic: DB2 for LUW

Subtopic: 2007



DATE: 2007-5-9 (01:40 PM - 02:40 PM)
SPEAKERS: Christina Lee (IBM Silicon Valley Laboratory)

Learn about the differences between traditional relational indexes and the new XML indexes making their exciting debut in DB2 9. Understand the basics of this new technology so you can start creating XML indexes to improve the performance of your queries on XML documents. Pick up valuable tips to avoid common errors if you are a first-time user.

EXP. LEVEL: Beginner

OBJECTIVES:

Understand the differences between relational and XML indexes

Become familiar with the new CREATE INDEX syntax for indexes on XML columns

Learn how to avoid common user errors

Understand the eligibility requirements needed for queries to use XML indexes

Learn how the XML indexes are defined in the catalog



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.