How do you monitor if the indexes are being used in 8i? Individually the tkprof and explain plans do the trick. However from a running system, how can the index usage be determined?
If the index is being used? How many times did the index get used during a specific time frame etc.
Regards
Menon
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more