Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Enterprise
Expertise: All
Apr 14, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Optimize SQL Using "Show Statistics"

The new and improved showplan in SQL 7 is certainly prettier and easier to understand than the previous version. However, a better method of focusing on trouble spots is using show statistics. Execute your query with this option turned on, and you will get a detailed breakdown of how SQL Server spent its time running your query. Look for the areas that used the most logical I/O (physical I/O depends on what is in cache at the time and is therefore not a good measurement), and you will find the SQL that needs attention.
Joseph Lax
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date