Skip to Main Content
Using the IBM System Storage N Series with Databases
book

Using the IBM System Storage N Series with Databases

by Alex Osuna, Arthur Li, Sanjay Adhikary, Roger E. Sanders, Mika Nikolopoulou
August 2007
Intermediate to advanced content levelIntermediate to advanced
374 pages
10h 53m
English
IBM Redbooks
Content preview from Using the IBM System Storage N Series with Databases
Chapter 3. Introduction to IBM DB2 Universal Database 69
3.3 The DB2 query optimizer
The query optimizer is the key component in the performance of any Enterprise Database
Server. IBM has made more than a 25-year investment in enhancements to the DB2
cost-based, rule-driven optimizer with the goal of keeping it the best in the industry. A major
component of this effort is the implementation of the Starburst extensible optimizer in DB2
UDB. This allows IBM to add new intelligence to the optimizer without having to modify the
entire query-compilation process.
As DB2 UDB is enhanced with new features and functionality, the optimizer performance
improves. An example is extending the optimizer to understand OLAP SQL extensions and
multiple levels ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

IBM System Storage N series Clustered Data ONTAP

IBM System Storage N series Clustered Data ONTAP

Roland Tretau, Christian Fey, Michal Klimes, Steven Pemberton, Tom Provost, Youn-Ho Yang
IBM System Storage N series Software Guide

IBM System Storage N series Software Guide

Roland Tretau, Christian Fey, Michael Klimes, Steven Pemberton, Tom Provost, Danny Yang
IBM System Storage SAN Volume Controller, IBM Storwize V7000, and IBM FlashSystem 7200 Best Practices and Performance Guidelines

IBM System Storage SAN Volume Controller, IBM Storwize V7000, and IBM FlashSystem 7200 Best Practices and Performance Guidelines

Jon Tate, Tiago Moreira Candelaria Bastos, Jon Herd, Sang-hyun Kim, Sergey Kubin, Dirk Peitzmann, Antonio Rainero
Implementing the IBM Storwize V3700

Implementing the IBM Storwize V3700

Paulo Tomiyoshi Takeda, Chris Tapsell, Lee Sirett, Adam Lyon-Jones, Jon Tate

Publisher Resources

ISBN: 0738489166Purchase book