How can I enforce to use particular index?
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
Which is faster statement or preparedstatement?
how to use DTS package in 2000,2005,2008 in sql server
Does sql server 2016 have ssms?
Can I use sql azure as a backup with log shipping or database mirroring?
Why use stored procedures in sql server?
How to create sub reports?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Which tools are available to manage SQL Azure databases and servers?
What is data modeling and Reterminal integrity?
How to write an inner join with the where clause in ms sql server?
What are different replication agents and what's their purpose? : sql server replication
Describe how to use the linked server?
What are different types of views?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
How do I uninstall sql server 2014?