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

Status
Not open for further replies.
M

martinz

Guest
Ah, that's great. I have some large volatile tables (> 1.000.000.000 records, with 500.000.000 inserts per year), with indexes that I never see being used. Now that we need to do D&L, I can deactivate these indexes. Will help for idxbuild time, db size and general perf. I'm aware of the -tablerangesize and -indexrangesize settings; as I see creates and splits on those indexes, I assume the 0 reads on the indexes really mean they are not used. - martin

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

Similar threads

P
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: SQL Index usage recorded in index statistics?
Replies
0
Views
446
Patrice Perrot
P
C
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: SQL Index usage recorded in index statistics?
Replies
0
Views
573
ChUIMonster
C
M
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: SQL Index usage recorded in index statistics?
Replies
0
Views
494
martinz
M
C
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: SQL Index usage recorded in index statistics?
Replies
0
Views
426
ChUIMonster
C
M
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: Speed up Index Rebuild
Replies
0
Views
655
martinz
M
Top