(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