SQL*Plus SQL> set autotrace on
then run the query This will give you two sets of information: - Execution plan - Statistics The execution plan will tell you what indexes were used, what table/index ranges were scanned, etc. Axton Grams On Fri, Jun 26, 2009 at 11:12 AM, bruce sisk<[email protected]> wrote: > Hello, > > How can I test a query to see if it is using an index or performing a table > scan?? > > We are using Oracle 10g as our database. > > I am trying to optimize a query. I have looked at and applied the various > rules defined in Remedy documentation for optimizing, but would like to > test\validate that the indexes are in fact being used. > > Bruce Sisk > > ________________________________________ > PeoplePC Online > A better way to Internet > http://www.peoplepc.com > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
