Interested to Buy Any Domain ? << Click Here >> for more details...
how can we find the select statement is indexed or not?
- 3 Answers
- 17280 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / raji_4u
Check for "EXPLAIN PLAN".
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
What is benefit of creating memory optimized table?
What is sql keyword?
How do you modify a trigger?
What are the rules to be applied to nulls whilst doing comparisons?
What is example of database?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What are the basic techniques of indexing?
What is sqlexception in java?
What is varchar data type in sql?
What is the function that is used to transfer a pl/sql table log to a database table?
What are keys in sql?
Is it possible to create the following trigger: before or after update trigger for each row?
What is the advantage of index in sql?
What is the difference between delete and truncate commands?
What are pl/sql cursor exceptions?
