Essential Facts about Index Covering in DB2 Universal Database

From the developerWorks archives

Alexander Kuznetsov

Date archived: January 12, 2017 | First published: March 13, 2003

Author Alexander Kuznetsov uses examples to illustrate cases in which adding a column or two to an index can boost a query's performance by "covering" the columns used in a SELECT statement. The DB2 optimizer is very good in recognizing such situations and can choose a very efficient execution plan.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=14292
ArticleTitle=Essential Facts about Index Covering in DB2 Universal Database
publish-date=03132003