MySql带order by与limit的sql优化
(root@localhost:mysql.sock)[mm]explain select ID,ModeType,BusinessID,BusinessList,FlowStatus,CreateTime,Name,LastStepStatus FROM Rec_FS where FlowStatus <>2 and LastStepStatus = 1 ORDER BY CreateTime ASC LIMIT 0,
MySql带order by与limit的sql优化
(root@localhost:mysql.sock)[mm]explain select ID,ModeType,BusinessID,BusinessList,FlowStatus,CreateTime,Name,LastStepStatus FROM Rec_FS where FlowStatus <>2 and LastStepStatus = 1 ORDER BY CreateTime ASC LIMIT 0,