[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: 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
Thanks for your suggentions, very appreciated. I ran the SQL with the JDBC tool Squirrel and after my post i tried statistics as Mike mentioned too UPDATE STATISTICS UPDATE INDEX STATISTICS Then the Index for LastChanges was used and I got the results in the same time. "The SQL query processor uses completely different algorithms for deciding which indexes to use than the 4GL does. Among other things, it uses statistics of the number of rows, key distributions, and other info in its choices." As a SQL dummy I would prefer to ignore statistics and use the same logic as ABL does This means SQL Performance is poor without running the maintenance commands? Shall i run this one time a week (maybe Sunday without users)? UPDATE TABLE STATISTICS AND INDEX STATISTICS AND ALL COLUMN STATISTICS;

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