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>
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