Supported by real-world examples, you'll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications with extensive problems. Learn to: Determine if and where you can expect performance gains Apply quick fixes, such as limiting calls to the database in stored functions and procedures refactor tasks, such as replacing application code by a stored procedure, or replacing iterative, procedural statements with sweeping SQL statement refactor flow by increasing parallelism and switching business-inaugurated processing from synchronous to asynchronous design refactor using schema extensions, regular views, materialized views, partitioning, and more Compare before and after versions of the program to ensure you get the same results as you make changes SQL refactoring application teaches you to recognize and assess code that needs refactoring, and to understand the crucial link between refactoring and performance.