Which index

MiniMe · Post by **MiniMe** » Mon Apr 07, 2003 12:17 pm

One of our servers is performing slower than normal. We think it may be a bad index or one that needs updating. Is there a way with ltest or dumplock to see what indexes are being accessed??

Post by **John** » Mon Apr 07, 2003 1:04 pm

No, although you can look at the file access time. Only metamorph indexes need updating, and one rule of thumb is to look at the size of the _T.btr and _D.btr files, and if they are more than 100K in size that index is a good candidate for updating.