SELECT * FROM User ORDER BY UserName Limit 80000, 20超慢,怎么优化?SELECT * FROM User ORDER BY UserName Limit 80000, 20超慢,怎么优化?上面这条语句超慢,请问怎么优化?[解决办法]create index on User (UserName ,UserID );语句上没什么可优化的了,添加如上索引如仍不满意,则提高你的硬件速度。