Try show plan. I think it works for Oracle too. I know it does for MS-SQL. Joe
________________________________ From: bruce sisk <[email protected]> To: [email protected] Sent: Friday, June 26, 2009 12:12:15 PM Subject: Testing for Table Scan 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"
