how can we find the select statement is indexed or not?
Answer Posted / 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 View All Answers
How to run sql statements through the web interface?
What is difference between mysql and postgresql?
What is sql profiler in oracle?
How do you add a column to a table?
What is cartesian join in sql?
What is a nested table in word?
What is character functions?
What do you mean by query optimization?
Is a secondary key the same as a foreign key?
What is a join?
What is the largest value that can be stored in a byte data field?
what is myisam? : Sql dba
What is a sql statement?
What is the difference between a primary key and a unique key?
What are the types of queries in sql?