Unused and invalid indexes in Oracle 8.1.7.4
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Unused and invalid indexes in Oracle 8.1.7.4

  1. #1
    Join Date
    May 2003
    Posts
    12

    Unused and invalid indexes in Oracle 8.1.7.4

    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 8.1.7.4 ) to confirm that all my indexes have been created and working fine.

  2. #2
    Join Date
    Jan 2001
    Posts
    642
    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
    Posts
    295
    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