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 (cond1...or..cond2....or...cond3...and.....so 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,






Categories