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

How do I start pl sql?

950

How do I view output in sql developer?

1088

What does 0 mean in sql?

966

Which is faster view or stored procedure?

946

What is the difference between syntax error and runtime error?

1142

What is query optimization in sql?

985

Enlist the advantages of sql.

1001

What is sql scripting?

1124

How to fetch alternate records from a table?

1244

What is offset and limit in sql?

1059

Why truncate is used in sql?

1006

What is the default isolation level in sql server? : Transact sql

1025

What are the types of variables use in pl sql?

1044

Does truncate release storage space?

1079

Is sql a programming?

978