…EXPLAIN EXTENDED to see that MySQL rewrites the view query to include the restriction: mysql> explain extended… | key_len | ref | rows | filtered | Extra | +—-+————-+——-+——+—————+——+———+——-+——+———-+————————–+ | 1 | SIMPLE | t2 | ref…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
…few rows, even if some extra filtering takes place so you need … solution for this problem is ether extending your indexes so MySQL Optimizer … if it is quite fast: mysql> explain select * from test order by k limit 5; …
