Interested to Buy Any Domain ? << Click Here >> for more details...
How can I enforce to use particular index?
- 1 Answers
- 6052 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 |
Are semicolons required at the end of sql statements in sql server 2005?
What are the different types of backups that exist?
Find first and last day of current month in sql server
What are window functions in sql server?
How to write an inner join with the where clause in ms sql server?
What is a result set object returned by odbc_exec()?
How to provide login information for a new odbc dsn?
How to create hyperlink from returned sql query ?
What are the results of running this script?
How to find 6th highest salary from Employee table ?
Explain contrast amongst grouped and non-bunched records?
How many levels of sp nesting is possible?
-
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)
