Just like relational indexes, XML indexes on DB2 9 pureXML are used to improve the performance of queries. The user should always create indexes over frequently accessed data, resulting in significant performance gains for the select statements executed over the indexed data. Although indexes usually present very positive performance gains for select statements, other statements like insert/update/delete may have their performance slightly decreased, since index keys may need to be created or deleted when these statements are executed. This paper provides a short introduction to index creation over XML documents on DB2 9 pureXML. This paper covers the basics of the CREATE INDEX statement and explain in detail some of the parameters for this statement.
Did you find this white paper useful?
Related white papers
Web Services Programming Using Java Technology and XML
The session starts with an introduction of fundamental concepts and characteristics of Web services. It will be followed by the detailed explanation on how to implement, how to describe, how...
Advanced ADO.NET
This session will look at how ADO.NET extends the familiar ADO model to provide built-in support for your current and next generation applications. ADO.NET provides both connected and disconnected access...
Live From Redmond: VB9 - Introduction to LINQ in Visual Basic
LINQ stands for Language Integrated Query and it allows querying over things like objects, databases and XML in a standard way with a new syntax available in the latest versions...
Web Services Interoperability Between Apache Axis2 and the WebSphere Web Services Feature Pack, Part 1
The WebSphere Application Server Version 6.1 Feature Pack for Web Services (hereafter called WSFP) includes a set of Java API for XML-based Web Services (JAX-WS) samples. These samples demonstrate the...
MSDN Webcast: .NET Language Integrated Query (Level 100)
Language Integrated Query (LINQ) provides the ability to write query expressions directly within Microsoft Visual C# or Visual Basic. LINQ makes it significantly easier to query and access all types...
MSDN geekSpeak Webcast: Building Silverlight Gadgets With Al Alper (Level 100)
The presenters share their knowledge and experience around a particular developer technology, and are ready to answer the questions real-time during the webcast. The attendee of this webcast will learn...
Smart Phone Software Developer Increases Download Speed and Revenue by 30 Percent
With more and more people conducting business while out of the office, the ability to increase mobile productivity has never been more important. Quickoffice has furthered that productivity by creating...
