[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Check for redundant indexes

[George Potemkin]

> Can you elaborate on that George? For example, if in addition to the indexes mentioned above there is Index3 on the SaleDep field then the query: for each Sale where SaleDate eq "..." and SaleDep eq "..." will use the two indexes: Index2 and Index3 But only if Index2 exists. Otherwise the query will use only one index (either Index1 or Index3 - depending from ...)

Continue reading...