Refactoring SQL applications
What can you do when database performance doesn't meet expectations? This book offers methods for refactoring (or changing) SQL code to improve performance without altering a database application's purpose -- and helps you do it on a shoestring budget. This isn't a rehash of theory, b...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | English |
| Published: |
Sebastopol, Calif.
O'Reilly Media
2008
|
| Edition: | 1st ed |
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- 1. Assessment
- A Simple Example
- Assessing Possible Gains
- 2. Sanity Checks
- Statistics and Data Skewness
- Indexing Review
- Parsing and Bind Variables
- Bulk Operations
- Transaction Management
- 3. User Functions and Views
- User-Defined Functions
- Views
- 4. Testing Framework
- Generating Test Data
- Comparing Alternative Versions
- 5. Statement Refactoring
- Execution Plans and Optimizer Directives
- Analyzing a Slow Query
- Refactoring the Query Core
- Rebuilding the Initial Query
- 6. Task Refactoring
- The SQL Mindset
- Restructuring the Code
- 7. Refactoring Flows and Databases
- Reorganizing Processing
- Shaking Foundations
- 8. How It Works: Refactoring in Practice
- Can you Look at the Database?
- Queries of Death
- All These Fast Queries
- No Obvious Very Wrong Query
- Time to Conclude
- A. Scripts and Sample Programs
- B. Tools