PostgreSQL query optimization : the ultimate guide to building efficient queries /

Write optimized queries. This book helps you write queries that perform fast and deliver results on time. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers. Any motivated professional can learn to write efficient queries from the get-go and c...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Dombrovskaya, Henrietta (Autor), Novikov, Boris (Autor), Bailliekova, Anna (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [New York, NY] : Apress, [2021]
Temas:
PostgreSQL.
PostgreSQL
Querying (Computer science)
Bases de données > Interrogation.
online searching.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 1. Why Optimize?
  • 2. Theory: Yes, We Need It!
  • 3. Even More Theory: Algorithms
  • 4. Understanding Execution Plans
  • 5. Short Queries and Indexes
  • 6. Long Queries and Full Scans
  • 7. Long Queries: Additional Techniques
  • 8. Optimizing Data Modification
  • 9. Design Matters
  • 10. Application Development and Performance
  • 11. Functions
  • 12. Dynamic SQL
  • 13. Avoiding the Pitfalls of Object-Relational Mapping
  • 14. More Complex Filtering and Search
  • 15. Ultimate Optimization Algorithm
  • 16. Conclusion.

Ejemplares similares