Description |
1 online resource (xv, 277 pages) : illustrations |
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 |
Summary |
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, but a tested set of options for making code modifications to dramatically improve the way your applications function |
Analysis |
Databases |
Notes |
Copyright © O'Reilly Media, Inc. 2008 |
|
Print version record |
Subject |
SQL (Computer program language)
|
|
Database management.
|
|
COMPUTERS -- Programming Languages -- SQL.
|
|
SQL (Computer program language)
|
|
Database management.
|
|
Database management
|
|
SQL (Computer program language)
|
Form |
Electronic book
|
Author |
L'Hermite, Pascal
|
ISBN |
9780596514976 |
|
0596514972 |
|
9780596551773 |
|
0596551770 |
|
9780596154950 |
|
059615495X |
|