tags:

views:

32

answers:

1

How can i do sql query optimization in sql server please explain me

+1  A: 

This is a very broad subject and your answer could range from understanding the differences between JOINs and subqueries to indexing. Actually inspecting the execution plans within SQL server may require a bit of a learning curve. I have been writing SQL for around 4 years now and have really only seen the tip of the iceberg regards these.

brumScouse
Plese give me the best point at least a few which are very essential to understand. My interviewer asked me this Question and i cud not answer this please explain me sir
NoviceToDotNet
How much time do we still have for answer preparation?
vgv8
please help me with this please give me some pins in minimum amount of time which you can afford
NoviceToDotNet