[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: SQL Index usage recorded in index statistics?

Status
Not open for further replies.
C

ChUIMonster

Guest
Statistics for both 4gl and SQL clients are tracked. The most common issue is that -tablerangesize and -indexrangesize are not set adequately to cover the tables and indexes in use. By default only 50 of each are tracked. (And it is not the "top 50", the tracking is based on table id number and index id number. So that is the first 50 tables in your db and the first 50 indexes.)

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