How can I enforce to use particular index?
- 1 Answers
- 5437 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 factors you will consider calculating the storage requirement for that view?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
How to start sql server browser service?
Why it is recommended to avoid referencing a floating point column in the where clause?
What are the differences between ms sql server & oracle?
what is denormalization? : Sql server database administration
Which are new data types introduced in sql server 2008?
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.
How to generate create function script on an existing function?
Give an example of why you would want to denormalize a database
How connect excel to sql server?
How you can get a list of all the table constraints in a database? : Sql server administration
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
