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

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Faroult, Stéphane
Otros Autores: L'Hermite, Pascal
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Sebastopol, Calif. : O'Reilly Media, 2008.
Edición:1st ed.
Temas:
SQL (Computer program language)
Database management.
SQL (Langage de programmation)
Bases de données > Gestion.
COMPUTERS > Programming Languages > SQL.
Database management
Databases
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares