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 do you migrate data from mssql server to azure?

165

What is linked report?

119

Explain the truncate command?

918

What is history table in sql server?

895

Do you know what is lock escalation?

963

Explain what stored procedure sp_replcounters is used for? : sql server replication

1453

What is data file in computer?

892

What is the stuff?

948

What is the significance of master, tempdb and model databases?

1024

What is cursor in ms sql server?

1090

Do you know what is fill factor and pad index?

940

Explain the concept of recursive stored procedure.

879

What is user-defined functions? What are the types of user-defined functions that can be created?

980

What is executereader?

897

What do you mean by a Composite primary key?

1029