how can we find the select statement is indexed or not?
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 |
Post New Answer View All Answers
what is try_catch block in procedure
Is it possible for a table to have more than one foreign key?
Does sql full backup truncate logs?
Is it possible to sort a column using a column alias?
Is sql a microsoft product?
What is the purpose of primary key?
Which one is better sql or oracle?
Is a secondary key the same as a foreign key?
Difference between truncate, delete and drop commands?
Can you call pl/sql package functions from within a fast formula?
What is oracle and pl sql?
how to include character strings in sql statements? : Sql dba
What are different types of queries in sql?
What do you mean by query optimization?
How do you modify a trigger?