O'Reilly logo

Dynamic SQL: Applications, Performance, and Security by Edward Pollack

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Ed Pollack 2016

Edward Pollack, Dynamic SQL, 10.1007/978-1-4842-1811-2_6

6. Performance Optimization

Edward Pollack

(1)Albany, New York, USA

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required