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

From: Patrick J. Hayes <pjh_at_ngdc.noaa.gov>
Date: Thu, 01 Feb 2001 09:46:08 -0700
Message-ID: <3A7992CF.C6043EA2_at_ngdc.noaa.gov>


[Quoted] [Quoted] I'm testing the search speed of oracle tables using different indexes. [Quoted] 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 [Quoted] at Explain, analyze, and explain plan., but its not really what I'm after.
Any suggestions?

Patrick Hayes Received on Thu Feb 01 2001 - 17:46:08 CET

Original text of this message