From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.tools Subject: Re: Which oracle command to use to find out which index was used Date: Fri, 2 Feb 2001 20:36:06 +0100 Message-ID: References: <3A7992CF.C6043EA2@ngdc.noaa.gov> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 X-Complaints-To: abuse@nl.demon.net NNTP-Posting-Host: sybrandb.demon.nl X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78 X-Trace: beta-news.demon.nl 981142444 beta-news:59742 NO-IDENT sybrandb.demon.nl:212.238.21.78 Lines: 35 "Matt B." wrote in message news:t7k9ac1k1quu8a@corp.supernews.com... > "Patrick J. Hayes" wrote in message > news:3A7992CF.C6043EA2@ngdc.noaa.gov... > > 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 > > As another poster said, do an alter session set SQL_TRACE=TRUE and then use > tkprof to read the output .trc file. > > Also, I believe TOAD has this functionality too - just type in your query and > hit the iconic button that has the ambulance on it and it'll tell you. > > -Matt > > Or for those with RSI problems: press Ctrl-E Hth, Sybrand Bakker, Oracle DBA