how can we find the select statement is indexed or not?
Answers were Sorted based on User's Feedback
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 |
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 |
Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974
What is a trigger word?
How do I install microsoft sql?
How to place comments in pl/sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
What type of database is cloud sql?
How to handle bulk data?
Why we use cross join?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
What are different sql data types?
What is use of term?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)