Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What are the main factors in SQL Server queries optimization?

Queries SQL Server 2000 2008 T SQL Microsoft SQL Server Technology
user-image
Question added by ziad jendi , Technical Lead Manager , Innovent Integrated Solutions
Date Posted: 2016/02/16
Upvote (0) Views (25) Followers (3) Answers (3) Report Question
Write an Answer
Register now or log in to answer.
Ahmed Al Mostapha Amezzane
by Ahmed Al Mostapha Amezzane , Technicien specialise en informatique , COD2I

AT A GLANCE:

Analyzing execution plans

Optimizing queries

Identifying queries to tune

 

Syed Furquan Ahmed
by Syed Furquan Ahmed , Senior Software Engineer , Saudi Systems Corporation

The factors that involve in Optimizing Query in SQL Server are:

  • Analyzing the query execution plan
  • Minimizing the number of implicit connections.
  • Eliminating the data reading.
  • Getting rid of the procedural code.
  • Excessive index fragmentation.

 

ziad jendi
by ziad jendi , Technical Lead Manager , Innovent Integrated Solutions

I think simply they are as the following:

1- Indexes.

2- Statistics.

3- Execution plans.

4- Query hints.

 

 

Write Your Answer
More Questions Like This