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