Storage Management White Papers
Exploit XML Indexes for XML Query Performance in DB2 9
Overview DB2 9 provides pureXML storage and offers XQuery and SQL/XML as query languages. XML indexes are essential for high query performance, but their usage for query evaluation depends on how query predicates are formulated. This paper presents a set of guidelines for writing XML queries and creating XML indexes in a consistent manner so that indexes speed up the queries as expected. Also learn what to look for in XML query execution plans to detect performance issues, and find out how to fix them. A downloadable "Cheat sheet" summarizes the most important guidelines.
| Publisher | IBM | File Format | HTML |
|---|---|---|---|
| Date Published | November 2006 | ||
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 2 out of 4 users found this white paper useful
White Paper RSSIBM Think Tank: Insights for Your Business
DownloadThink Tank has been designed specifically for businesses like yours. We aim to give you simple, clear advice and information that gets to the point fast. Our insights could make...
A Guide to Storing More Intelligently
With enterprise IT organizations battling year-over-year information growth rates of 50 to 60 percent, we need to start storing information more intelligently. This will improve energy efficiency, reduce system complexity...
A Guide to Virtualising Your Information Infrastructure
Today, Virtualisation is at the top of every IT shop's "must-have" lists as CIOs and data center managers look to tackle challenges such as system growth, complex servers and storage,...
Green Data Center Storage Part II: Sustained Cost Effectiveness in Transitioning Times
This is the second part of a three-part paper on Data Center Power and cooling. It discusses data and disk types and how to match data and disks effectively within...
Allocating Disk Space
The powerful abstraction provided by network storage virtualization software has finally and fully taken shape. Its compelling economic value is derived from the software’s ability to compensate for many of...
