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

  • Thread starter Thread starter Stefan Marquardt
  • Start date Start date
Status
Not open for further replies.
S

Stefan Marquardt

Guest
I think I'm running a 100% identically query, one with SQL and the other in ABL. TABLE has Index for LastChanged and FIELD. Both contains one field only select * from TABLE WHERE LastChanged Squirrel) >> This uses the index of FIELD -> very bad because the order is by LastChanged!! FOR EACH TABLE WHERE LastChanged > This uses the index of LastChanged -> result very fast What is the problem that the SQL query uses the wrong index and therefor runs endless on a large table (like fullscan)?

Continue reading...
 
Status
Not open for further replies.
Back
Top