1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / bmsrao

Answers were Sorted based on User's Feedback



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

Answer / raji_4u

Check for "EXPLAIN PLAN".

Is This Answer Correct ?    16 Yes 2 No

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

Answer / 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

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

Answer / tushar

SELECT * FROM ALL_INDEXES
WHERE OWNER = 'MYUSERNAME' AND TABLE_NAME ='MYTABNAME' AND INDEX_NAME = 'MY_IND_NAME'

Is This Answer Correct ?    3 Yes 8 No

Post New Answer

More SQL PLSQL Interview Questions

What is trigger with example?

0 Answers  

what are sequences

0 Answers  

How many types of privileges are available in sql?

0 Answers  

What are the types of variables use in pl sql?

0 Answers  

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  




What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

how can we know the count/number of elements of an array? : Sql dba

0 Answers  

What is the sql*loader? : aql loader

0 Answers  

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

who introduced sql?

0 Answers  

How to perform a loop through all tables in pl/sql?

4 Answers   Evosys, MBT,

For more SQL PLSQL Interview Questions Click Here
Categories