1 Reply Latest reply: Mar 21, 2013 4:49 AM by John Stegeman RSS

    Check Index used in an oracle select query

    Arun Natarajan-OC
      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
          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?