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

When is a declare statement required?

1193

What is execute immediate?

1161

What are field types?

1051

what is self-join? : Sql dba

1239

What are crud methods?

1084

Explain how exception handling is done in advance pl/sql?

1045

What is a system versioned table?

1040

What is a trigger word?

1077

What is asqueryable?

1035

Define commit, rollback and savepoint?

1081

What is a constraint?

1082

Can we use view in stored procedure?

953

How is pl sql different from sql?

1142

What is the difference between execution of triggers and stored procedures?

1155

What is sharding in sql?

1039