Advanced SQL Tuning

In the last chapter, we emphasized that high-performance stored programs require optimized SQL statements. We then reviewed the basic elements of SQL tuning namely, how to optimize single-table accesses and simple joins. These operations form the building blocks for more complex SQL operations.

In this chapter, we will look at optimizing such SQL operations as:

• Subqueries using the IN and EXISTS operators
• "Anti-joins" using NOT IN or NOT EXISTS
• "Unamed" views in FROM clauses
• Named or permanent views
• DML statements (INSERT, UPDATE, and DELETE)