Check for "EXPLAIN PLAN".

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

Question Posted / raji_4u

Answer Posted / raji_4u

Is This Answer Correct ?

16 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a trigger word?

1081

What are sql indexes?

1047

how to create a table index in mysql? : Sql dba

1126

Why partition by is used in sql?

1083

What is foreign key sql?

1041

What are the different types of tables in sql?

1068

Mention what are different methods to trace the pl/sql code?

1296

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1228

what is a field in a database ? : Sql dba

1099

Is pl sql still used?

1018

What is autocommit sql?

1044

What is the use of count (*) in sql?

1119

What are the basic sql commands?

1142

Explain how can you save or place your msg in a table?

1078

What is the difference between left join and right join?

990