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

Is sql a programming?

0 Answers  

Difference between a query and strored procedure?

4 Answers   Microsoft,

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

What is difference between cursor and ref cursor?

1 Answers  

How is pl sql different from sql?

0 Answers  




What is difference between stored procedure and trigger?

0 Answers  

What is meant by <> in sql?

0 Answers  

What is sql*loader?

0 Answers  

What are tables and fields?

0 Answers  

What is sql architecture?

0 Answers  

what is definer rights invoke rights?

1 Answers  

Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories