ok

The Fundamentals of Execution Plans and SHOWPLAN in SQL Server



This video is part of LearnItFirst’s Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here: …

source

Tags

Related Articles

11 Comments

  1. Great video .. an additional suggestion would be extracting execution plans using showplan and saving them in XML which would save considerable time when the host server or application server is restarted which usually flushes the cache memory where execution plans are stored .. this way you could save time on unchanged frequent queries by reusing the saved execution plan XML using useplan .. Hope that helps ..

Leave a Reply

Back to top button
Close