Chapter 9. Querying XML Data: Advanced Queries & Troubleshooting
In this chapter we discuss advanced XML query topics, common errors, and guidelines for avoiding performance pitfalls. The examples include both XQuery and SQL/XML queries. This chapter is organized along the following topics:
• Aggregation and grouping in XML queries (section 9.1)
• Joins between XML columns as well as joins between XML and relational data (section 9.2)
• XML queries with case-insensitive string predicates (section 9.3)
• Guidelines for avoiding common performance problem (section 9.4)
• Common errors in XML queries and how to resolve them (section 9.5)
9.1 Aggregation and Grouping of XML Data
The recommended and most efficient way to perform ...
Get DB2® pureXML® Cookbook: Master the Power of the IBM® Hybrid Data Server now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
