Re: Is my query using index

Hi Kumar,

You can use EXPLAIN PLAN command to see how Oracle optimizer execute SQL operator.

It's look like his command from SQL*Plus:

EXPLAIN PLAN
SET STATEMENT_ID = 'my_query'
INTO MY_PLAN_TABLE
SELECT ename, job
From emp
Where ...

As result you assume records in MY_PLAN_TABLE with comments like FULL SCAN, INDEX ACESS, etc.

Description of EXPLAIN PLAN is provided in Oracle Server documentation.

Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com

kumar_kmk_at_hotmail.com (Kumar) wrote in message news:<bce41b15.0209291957.520c21b0_at_posting.google.com>...
> If there is a index created on a table, and a query is run against the table
> how do I know if the index is being used or not.
Received on Mon Sep 30 2002 - 16:13:41 CEST