three important notes in MYSQL performance optimization : -
- Covered indexes are a great MySQL feature and, in most cases, can increase MySQL performance significantly.
- Some queries may also be optimized with a separate index, which will enable the loose index scan algorithm.
- "Order by" optimizations can be done with a covered index and with the "order by+limit" index technique
コメント