Tuesday, December 25, 2007

So You Are Tuning Some Bad SQL Statement....

Sql statement tuning is the hardest tuning I guess. Its having so many things to look after, the query itself, question which is asked for which the query is written, missing indexes , bad execution plan and the list goes on and on and on. So how can you be some what good in solving this impossible looking puzzle of statement tuning? Greg Rahn has posted a very good post for troubleshooting bad execution plans. Its a must read in my opinion as execution plan is like the x-ray report of your statement's flow and by tuning how is your statement is going through, you can get the maximum performance! Have a read, its an excellent post!

0 Comments:

Post a Comment

<< Home