Community

Essential Facts about Index Covering in DB2 Universal Database

(Alexander Kuznetsov) This article 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 executi

Read More - Register for Free Membership

Tags: