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"
