
Handling ORDER BY with LIMIT queries
Available means to produce ordered streams:
● Use an ordered index
○ Range access
○ Ref access (but not ref-or-null)
■ Result of ref(tbl.keypart1=const) are ordered by tbl.keypart2,t.keypart3…..
○ Index scan
● Use Filesort
评论