Articles & Content

Archives

Getting Started with XML Indexing in DB2 9 (H10)

Topic: 2007 NA

Subtopic: DB2 for LUW



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



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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