Unused and invalid indexes in Oracle 8.1.7.4

[badrinathn]

For some or (all) your queries, run the explain plan and see if the Indexes are being used. If not rebuild the index.
2) Try to analyze the tables.