Optimization Rules of Thumb

Posted by:sukanyakaur 1258 days ago • 2 Comments • http://toostep.com

Optimization Rules of Thumb Always look at the query plan first. It will show you the optimal current execution plan from the query engine's point of view. Find the most expensive part of the execution plan and start optimizing from there. However, even before that, make sure that the statistics on all tables in your query are up to date, by running the update statistics TableName command on...

optimization       sql optimization       rules       sql       thumb