Which indexes are not used

Hello,
Our database (Oracle 7.3.3.6, VMS ALpha 7.1) is reported to be running very slow. After looking at Toad - monitor option, I discovered
that only 33 % of the queries are using indexes and rest are non-indexed queries. I gather that this is leading to large table scans thereby leading to I/O bottleneck.
We have indexes for all the tables in place and no one has dropped the indexes. So why the problem is happening today?

My questions are:-

1. How to find out which query is not using indexes?
2. Why are they not using indexes?
3. Which indexes are not used?

About 75 users are logged into the database and I dont know how to identify which uses is creating the bottleneck.

Any hint/ideas would be greatly appreciated.

Please send a copy of your reply to
s_c_99_at_hotmail.com as well.

Thanks in advance.

s_c_99_at_hotmail.com Received on Thu Apr 06 2000 - 05:04:05 CDT