Acabo de encontrar un libro totalmente gratuito dónde enseñan a mejorar el rendimiento de nuestras bases de datos relacionales.
Su índice es el siguiente:
- CHAPTER 1 – Anatomy of an Index
- CHAPTER 2 – The Where Clause
- CHAPTER 3 – Testing and Scalability (not yet published)
- CHAPTER 4 – Joins (not yet published)
- CHAPTER 5 – Fetching Data (not yet published)
- CHAPTER 6 – Sorting, Grouping and Partitioning (not yet published)
- CHAPTER 7 – Views (not yet published)
- CHAPTER 8 – Advanced Techniques (not yet published)
- CHAPTER 9 – Insert, Delete and Update (not yet published)
- APPENDIX A – Execution Plans
- APPENDIX B – Myth Directory
Si constantemente trabajas con bases de datos, este libro puede ser de mucha utilidad.
SQL Performance Explained | Free SQL Tuning and Indexing e-book Download