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 nvarchar max in sql?

1008

What are aggregate functions in sql?

1151

What is the maximum database size for sql express?

1019

What is a constraint? Tell me about its various levels.

1153

what is a composite primary key ? : Sql dba

1044

How to execute a stored procedure?

1084

Show how functions and procedures are called in a pl/sql block.

1116

What is the difference between left outer join and left join?

989

How do I run a query in pl sql developer?

986

Do we need to create index on primary key?

921

What is difference between rank () row_number () and dense_rank () in sql?

1097

Why we use pl sql?

955

what are all different types of collation sensitivity? : Sql dba

978

What is form and report?

971

What is package in pl sql?

1011