full table scans, 1693 full-text queries, 1718 indexes, 1715 INFORMATION_SCHEMA queries, 1708 InnoDB tables, 1745 INSERT statements, 1713 many tables, 1736 MEMORY storage engine, 1719 MEMORY tables, 1761 memory usage, 1835 Multi-Range Read, 1670 MyISAM tables, 1757 nondeterministic functions, 1689 numeric types, 1735 Performance Schema queries, 1711 PERFORMANCE_SCHEMA, 1843 primary keys, 1716 REPAIR TABLE statements, 1760 SELECT statements, 1640 SPATIAL indexes, 1716 spatial queries, 1718 SQL statements, 1640 subqueries, 1694 subquery, 1699 subquery materialization, 1698 tips, 1714 UPDATE statements, 1713 views, 1694 WHERE clauses, 1641 window functions, 1691 optimization (NDB), 1656, 4180 optimizations, 1651 LIMIT clause, 1686 row constructors, 1692 optimize option mysqlcheck, 468 OPTIMIZE TABLE and partitioning, 4701 OPTIMIZE TABLE statement, 2895 optimizer, 6173 and replication, 3669 controlling, 1780 cost model, 1809 new features, 24 query plan evaluation, 1780 switchable optimizations, 1781 optimizer hints, 1791 optimizer statistics for InnoDB tables, 3131 Optimizer Statistics, 3138 optimizer_prune_level system variable, 848 optimizer_search_depth system variable, 848 optimizer_switch system variable, 849, 1781 use_invisible_indexes flag, 1728 5498