8
Hidden Performance Tips
In previous chapters, we have shown that adding indexes can dramatically improve SQL performance. There are additional ways to improve index efficiency further. Various techniques can be used to simplify or reduce SQL statements to create an immediate performance and throughput improvement.
In this chapter we will be discussing several performance tips:
• Removing duplicate indexes
• Identifying unused and ineffective indexes
• Improving indexes
• Eliminating SQL statements
• Simplifying SQL statements
• Caching options
Index Management Optimizations
The management of indexes—how they are created and maintained—can ...
Get Effective MySQL Optimizing SQL Statements now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
