整个查询返回了是不是30多w
SELECT/*+full(POSTINFP) */*
FROM POSTINFO WHERE (IS_TOP_FIRST=1
OR ((CATALOG_ID=84 OR CATALOG_ID=94)
AND BAR_ID NOT IN(470,482,9023,9024,9025,9027,928,422)))
AND ISDELETED = 0ORDER BY IS_TOP_FIRST DESC,REPLY_TIME_MS DESC
SELECT*
FROM POSTINFO WHERE (IS_TOP_FIRST=1
OR ((CATALOG_ID=84 OR CATALOG_ID=94)
AND BAR_ID NOT IN(470,482,9023,9024,9025,9027,928,422)))
AND ISDELETED = 0ORDER BY IS_TOP_FIRST DESC,REPLY_TIME_MS DESC
对比下这2句的逻辑读 |