execution plans: what can you do with them
TRANSCRIPT
Goals
• Understand the degree to which SQL Server internals are exposed through execution plans
• Learn methods for reading execution plans to expand your knowledge
• Understand ways in which you can apply this information in your own code
THE QUERY OPTIMIZER
User Defined Functions
• Multi-statement table valued user defined functions• AKA: Pure Evil!
• Scalar functions
• Inline table functions• AKA: parameterized views
Conclusion
• It’s not just about query tuning
• You can actually see functionality
• Observation leads to knowledge
• Still just a representation
References
• Fabiano Amorim
• Paul White
• Rob Farley
• SQL Server Execution Plans, Grant Fritchey