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

Answer Posted / raji_4u

Check for "EXPLAIN PLAN".

Is This Answer Correct ?    16 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we create stored procedures & functions in pl/sql and how are they different?

504


Does sap use sql?

519


What is a sql profiler?

592


How do you respond to dementia behavior?

533


Is sql a dbms?

536






How many developers work on postgresql?

568


How to know the last executed procedure?

591


Is id a reserved word in sql?

667


Do prepared statements prevent sql injection?

532


how to get a list of columns in an existing table? : Sql dba

545


Does sql full backup truncate logs?

533


How many types of privileges are available in sql?

739


what is acid property in database? : Sql dba

561


What is an inner join sql?

549


How many types of keys are there in sql?

557