To check the statement is indexed or not via AUTO Trace -Â Trace only co

how can we find the select statement is indexed or not?

Question Posted / bunty

Answer Posted / bunty

To check the statement is indexed or not via AUTO Trace -Â
Trace only command

Cheers,
Bunty

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is over () in sql?

891

What is %type in pl sql?

923

Give the order of sql select?

1085

How to select random rows from a table?

1018

What is mutating error in pl sql?

961

How delete all data from table in sql?

947

What is java sql package?

1023

How to load data with sql*loader?

994

what are the authentication modes in sql server? : Sql dba

997

What does the base_object_type column shows in the user.triggers data dictionary view?

994

What is materialized view. What are different methods of refresh?

1328

What is loop in pl sql?

979

what are the join types in tsql? : Transact sql

980

define data blocks ? : Sql dba

927

What are the two types of cursors in pl sql?

1001