This discussion is archived
1 Reply Latest reply: Mar 21, 2013 2:49 AM by John Stegeman RSS

Check Index used in an oracle select query

Arun Natarajan-OC Explorer
Currently Being Moderated
Hi Friends,

I have partitioned an oracle table and created Local Index for the Partitioned table .

Now i want to make sure that the Local index is being used when i perform select query on the Table partition.

How do i confirm that ?

can i check the explain plan generted for the select query to confirm local index is being used ?

Please let me know.

Regards,
DB
  • 1. Re: Check Index used in an oracle select query
    John Stegeman Oracle ACE
    Currently Being Moderated
    Now i want to make sure that the Local index is being used when i perform select query on the Table partition.
    Why? Have you proven that using this local index is the "best" plan?

    How do i confirm that ?
    can i check the explain plan generted for the select query to confirm local index is being used ?
    When I asked Google "how to read an oracle explain plan," I found lots of information - what did you find?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points