How can I enforce to use particular index?
- 1 Answers
- 5582 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
Is sql server difficult to learn?
How do indexes help, types?
How to change the data type of an existing column with "alter table" statements in ms sql server?
How can we remove orphan records from a table?
What are the requirements to use odbc connections in php scripts?
Explain what is the main purpose of having conversation group?
What is the difference between DATETIME2 and DATETIME?
How do you start single user mode in clustered installations?
What is snapshot replication?
How to execute function in stored procedure sql server?
What are the essential components of sql server service broker?
What is difference between global temporary tables and local temporary tables?
What are the different types of upgrades that can be performed in sql server?
What are transactions and its controls?
How to get a list of columns in a view using "sys.columns" in ms sql server?
