8.2.1. Optimizing SELECT Statements

8.2.1.1. Speed of SELECT Statements
8.2.1.2. How MySQL Optimizes WHERE Clauses
8.2.1.3. Optimizing LIMIT Queries
8.2.1.4. How to Avoid Full Table Scans

Queries, in the form of SELECT statements, perform all the lookup operations in the database. Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight reports.




Spec-Zone.ru - all specs in one place