通常情况下，为了实现高效分页，需要在查询中WHERE条件列和排序列应用组合索引。
例如，建立索引(a,b,c)使得以下查询可以使用索引，提高查询效率：
1、字段排序
ORDER BY a
ORDER BY a,b
ORDER BY a, b, c
ORDER BY a DESC, b DESC, c DESC
2、筛选和排序
WHERE a = const ORDER BY b, c
WHERE a = const AND b = const ORDER BY c
WHERE a = const ORDER BY b, c
WHERE a = const AND b
注册
登录
