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...
Continue reading...