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 |
How to sort the rows in sql.
Is truncate ddl or dml?
how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?
What is cursor in pl sql with examples?
What is group function in sql?
Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...
i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent
If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?
Are dml statements autocommit?
What is sql query optimization?
What are aggregate and scalar functions?
How many types of index are there?
Oracle (3259)
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)