一千多万的短信,配置了partition, order by create_date desc 时很快,
但是缺少索引,查询还是很慢
[img]http://dl2.iteye.com/upload/attachment/0106/4167/9b6640f8-600c-31f7-a530-831eb5bee551.jpg[/img]
但是缺少索引,查询还是很慢
[img]http://dl2.iteye.com/upload/attachment/0106/4167/9b6640f8-600c-31f7-a530-831eb5bee551.jpg[/img]