+ Reply to Thread
Results 1 to 3 of 3

Thread: Not Using Index

  1. 05-01-2001 01:38 PM #1
    Manikandan
    Manikandan is offline Junior Member
    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?
    Reply With Quote Reply With Quote
  2. 05-01-2001 01:46 PM #2
    pss
    pss is offline Member
    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.
    Reply With Quote Reply With Quote
  3. 05-01-2001 02:24 PM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,094
    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."
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width