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

How many types of cursors are available in pl/sql?

0 Answers  

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 Answers  

What is clause in sql?

0 Answers  

how to get help information from the server? : Sql dba

0 Answers  

What are the different type of joins in sql?

0 Answers  




What is data abstraction in sql?

0 Answers  

What are sql queries used for?

0 Answers  

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

What are the types of index in sql?

0 Answers  

What are the methods of filing?

0 Answers  

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

Difference between table function and pipelined function?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories