How can I enforce to use particular index?
- 1 Answers
- 5438 Views
- Symphony, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is query optimizer in sql server?
What is cross join in sql server joins?
What is truncate table?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What purpose does the model database server?
What is transaction server distributed transaction?
How does recursive cte works in sql server?
Tell me what is the difference between locking and multi-versioning?
Explain hostprotectionattribute in sql server 2005?
What is report server project?
Tell me what is the order in which the sql query is executed?
Can we use trigger new in before insert?
Which joins are sql server default?
What does executeupdate return?
What do you mean by sql server agent?
