Oracle is not using the index..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle is not using the index..

  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Oracle is not using the index..

    I am facing a strange oracle problem. We have a table with three columns . The first column is a primary key combination of second columna nd the third column.

    We have created three indexes.
    1. primary key index on first column
    2. index on second column
    3. index on the third column.

    We are doing simple select query on second and third column.
    During this query, Oracle is not using the index that is already presend on the table. It is doing a full table scan.

    By the way, we have cascade delete on the first column.

    Can some help or throw some light on this ?

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    I don't know if it's me or the reason for your index creations are hokey. Anyway, have you ran stats lately?

    How about posting the query you're running to give me (and the others)a look see at what you're trying to accomplish.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Can you give us ...

    i) Example data in the three columns

    ii) The exact query you are using, executed with "set autotrace on" to show the execution plan also.

    iii) a "Describe" of the table.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    When in doubt, bitchslap the developers!




    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by Mr.Hanky
    When in doubt, bitchslap the developers!




    MH
    you will respect my author-i-ty !
    I'm stmontgo and I approve of this message

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