How can I enforce to use particular index?

How can I enforce to use particular index? ..

Answer / 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

More SQL Server Interview Questions

What is Trigger?

3 Answers   Misys,

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE ( on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

whats new about truncate in sql server 2008?

0 Answers   Serco, MedSave Healthcare,

how to replace double quotes by single quotes in sql server

2 Answers   CAC,

why SQL server is more used to store database rather than Access

2 Answers  

what is package and it uses and how can u call a package

0 Answers   Satyam,

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

what is joins please explain breffly ??

1 Answers   TCS, Adaequare,