Not Using Index
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Not Using Index

  1. #1
    Join Date
    May 2001
    Location
    Bangalore
    Posts
    1

    Thumbs up

    We have a table in our database and an index defined properly on that table. SELECT queries on that table were using that index whenever executed. We did a REORG and after that SELECT queries on that table are not using that index at all. This caused a serious performance degradation on the database.

    What could be the reason?

  2. #2
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    Did you change any parameters in init.ora?
    Did you have table statistics in your data dictionary on the table?

    Sergey.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    is the index in UNUSABLE state?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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