Re: Which oracle command to use to find out which index was used

Turn trace for the session on, run your statement, turn trace off, format trace file with tkprof. It'll show you the real execution plan for this statement. If it's not enough, you'd have to read documentation first, particularly Oracle 8 Tuning.

In article <3A7992CF.C6043EA2_at_ngdc.noaa.gov>,   "Patrick J. Hayes" <pjh_at_ngdc.noaa.gov> wrote:
> I'm testing the search speed of oracle tables using different indexes.
> What command in oracle can I type to find out which index oracle used
> for my query. I believe the optimizer looks at the tables, indexes and
> so forth before deciding the best approach to run the query. I've
 looked
> at Explain, analyze, and explain plan., but its not
> really what I'm after.
> Any suggestions?
>
> Patrick Hayes
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 01 2001 - 19:50:31 CET