select c.*
from CMS_ARTICLE c
where c.cmar_State = 6
and c.cmar_Is_Delete = 2
and c.id != 7601291732376100
and c.cmar_Channel_Id = 282753409118476
order by c.cmar_Public_Date desc;
查询红色一段0.072秒,加上order by 要18秒。下面是表的索引:
也按照网上的方法,设置了workarea_size_policy,sort_area_size
重启数据库后还是不行。