|
|
|
|
|
|
|
|
|
What is a Trivial Execution Plan?
Does it make sense that not all queries are worth spending precious time optimizing, that it's better to just do the work now? How do you know when that is happening? Performance pro Grant Fritchey discusses some of the basic requirements for SQL to bypass optimization and how to tell when it has happened.
|
|
|
|
Duration:
|
1
mins
12
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.22
out of 5
|
|
Publish Date:
|
September 09, 2008
|
|
|
|
About the Author
|
|
I'm currently working for FM Global, an industry leading engineering & insurance company, as a DBA. I've done development of large scale applications in languages such as VB, C# and Java. I've worked in SQL Server from the hoary days of 6.0. My nickname at work is the "The Scary DBA." I even have an official name plate with it. I wear it proudly. I was awarded a Microsoft MVP in April of '09.
|
|
References
|
There are no downloads or recommended reading links for this video
|
|
|
Comments
|
rupesh sharma on
2/12/2009
Its very good example but it should elaborate more about the parameterization and some more detail about the understanding the execution plan with various type of examples. Thanks
|
|
|
Very interesting. I learned something new, so that's always cool. Curious to know more about what complexities might tip the scale away from a trivial plan (other than what was mentioned)
|
|
|
The parameter information was illuminating.
|
|
luther smith on
2/12/2009
Good to know!
|
|
|
Glad it was a little helpful. There's a whole slew of reasons that a plan would not be trivial. They're all available in BOL.
|
|
|
Would like to see more videos on SQL optimization (like stored procedures)
|
|
|
cool
|
|
|
Simple, good and to the point. Thank you.
|
|
|
good
|
Must Be Logged In
|
|
|
|
|