How you can find out if an index is useful to the optimizer?

Question Posted / anjani kumar

1 Answers
1004 Views
I also Faced
E-Mail Answers

How you can find out if an index is useful to the optimizer?..

Answer / Vinod Kumar Yadaw

You can check the query plan to determine whether an index is being used or not. If the 'Seek' operator is present in the execution plan, it means the index is being used.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL Server Interview Questions

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers

How can a user-defined datatype be created?

1 Answers

How to create function with parameter in sql server?

1 Answers

Can you use order by when defining a view?

1 Answers

What is sqlcmd?

1 Answers

How to insert multiple rows with one insert statement in ms sql server?

1 Answers

How to how to convert numeric expression data types using the convert() function??

1 Answers

What is exclusive locks?

1 Answers

What is the difference between a local and a global variable?

5 Answers

What is the Main Difference between ACCESS and SQL SERVER?

1 Answers MindCracker,

Tell me about pre-defined functions of sql?

1 Answers EXL,

What is the security principal at the server level that represents your session?

1 Answers

For more SQL Server Interview Questions Click Here