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

ow to bring suspect mode datbase online from scratch

1395

When would you use sql joins?

518

How to convert a table data in XML format in sql server?

2108

What are the various editions of sql server 2017 that are available in the market?

501

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

615

What is an indexed view?

575

What is sqlcmd?

547

What are system databases into sql server (2005/2008)?

572

How to connect sql server management studio express to sql server 2005 express?

572

Tell me in brief how sql server enhances scalability of the database system?

513

Explain having clause and where clause?

562

What is the command used to recompile the stored procedure at run time?

604

Does sql server 2016 have ssms?

502

What is best institute to Learn DotNET And SQL in chennai?

1684

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

597