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

Which is faster statement or preparedstatement?

921

how to use DTS package in 2000,2005,2008 in sql server

1819

Does sql server 2016 have ssms?

940

Can I use sql azure as a backup with log shipping or database mirroring?

156

Why use stored procedures in sql server?

991

How to create sub reports?

242

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1245

Which tools are available to manage SQL Azure databases and servers?

115

What is data modeling and Reterminal integrity?

1944

How to write an inner join with the where clause in ms sql server?

1073

What are different replication agents and what's their purpose? : sql server replication

994

Describe how to use the linked server?

1126

What are different types of views?

931

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

How do I uninstall sql server 2014?

918