Page 1 of 1

Which index

Posted: Mon Apr 07, 2003 12:17 pm
by MiniMe
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??

Which index

Posted: Mon Apr 07, 2003 1:04 pm
by John
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.