DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003

    Unused and invalid indexes in Oracle

    My application runs very slow after I did a database import.
    I doubt there is some problem in the indexes. I have the list of indexes used by my application with me.

    What all checks I can perform ( in Oracle ) to confirm that all my indexes have been created and working fine.

  2. #2
    Join Date
    Jan 2001
    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.
    There is always a better way to do the things.

  3. #3
    Join Date
    Jun 2000
    If your application ran fine before and bad after
    importing, calculate statistics may worth to check.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.