No discussion of Dynamic SQL would be complete without diving into its performance. Dynamic SQL can greatly improve performance, but can also increase complexity if not used effectively. As was the case with security, optimization is a topic that could easily occupy significantly larger books than this one. As such, this chapter focuses on Dynamic SQL and any performance concerns that relate to it.
Query Execution
Before jumping into the performance of Dynamic SQL and a variety of ways to monitor and tune performance, it is necessary to quickly review the process of query execution. What happens when you execute ...
