You can use index hint (index=index_name) after the table name. SELECT au

How can I enforce to use particular index?

Question Posted / saravakumar

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

Please Help Members By Posting Answers For Below Questions

How to concatenate two character strings together?

1170

What is cursor in ms sql server?

1204

What is the language structure to add a record to a table?

1077

What is view in sql?

955

Can group by be used without aggregate functions?

966

Please explain go command in sql server?

1113

How many types of attribute relationships are there? : sql server analysis services, ssas

1133

How to convert numeric values to integers in ms sql server?

1163

How do you migrate data from mssql server to azure?

167

What do you mean by a dependent functionality in a build?

1200

What happens to a statement batch if there is a compilation error?

1012

What is a user-defined function in the sql server and what is its advantage?

1141

What are the acid properties?

1060

What is difference between commit and rollback when used in transactions?

1019

What is an expensive query?

976