perfect...thanks. -----Original Message----- >From: Axton <[email protected]> >Sent: Jun 26, 2009 12:32 PM >To: [email protected] >Subject: Re: Testing for Table Scan > >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"
________________________________________ 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"
