Index covering and DB2 query performance

(Alexander Kuznetsov) When an index contains all the columns involved in a query, we usually say that an index covers a query. Whenever, this happens, the DB2 optimizer usually chooses to access only that index to satisfy a query, which is called index-only access or index covering. “Usually” does n

Read More - Register for Free Membership