Expert Performance Indexing in SQL Server
This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book,...
Autores principales: | , |
---|---|
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Berkeley, CA :
Apress
2015.
|
Edición: | 2nd ed. 2015. |
Colección: | Expert's voice in SQL server.
|
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630157506719 |
Tabla de Contenidos:
- Index fundamentals
- Index storage fundamentals
- Index metadata and statistics
- XML indexes
- Spatial indexing
- Full-text indexing
- Indexing memory-optimized tables
- Indexing myths and best practices
- Index maintenance
- Indexing tools
- Indexing strategies
- Query strategies
- Monitoring indexes
- Index analysis
- Indexing methodology.