How can I enforce to use particular index?
- 1 Answers
- 5580 Views
- Symphony, I also Faced
- E-Mail Answers
Answer / saravakumar
You can use index hint (index=index_name) after the table
name. SELECT au_lname FROM authors (index=aunmind)
| Is This Answer Correct ? | 7 Yes | 0 No |
What is the difference between osql and query analyzer?
What are various aggregate functions that are available?
What are the different type of replication in sql server?
In clustered and non clustered indexes which one is faster while executing a query ?
What command is used to rename the database?
How to read 2nd highest sal from EMP table?
How do you read transaction logs
What is the purpose of optimization?
Does partitioning improve performance sql server?
How to link tables in sql server?
What is Self Join?
hi i gone though satyam interview. what is Acid Properties?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
