[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Compare SQL query with ABL query, usage of the indexes

[Stefan Marquardt]

I ran now the statistic command : UPDATE TABLE STATISTICS AND INDEX STATISTICS AND ALL COLUMN STATISTICS; Then I have this SQL query, not very difficult: SELECT field0 from table WHERE field1 = 201903 AND field2 = 'XXX' AND field3 = 999 AND field4 = 'USD' AND (field5 = 6100 OR field5 = 6200) Indexes: One for field 1, one for field 3, one for field5 and many others I started the query with my JDBC tool and I'm waiting still, protop shows it's using index for field3. But field1 reduces the amount of records dramatically. The same in ABL displays the values at once! Really, at once!

Continue reading...