90W 记录得表count怎么这么慢?
udt_data_piece表 90W记录
Select Count(dataid) From udt_data_piece
上边语句count一下 大概2秒
可下边语句count一下 就要40多秒
大家看看怎么能优化呢?
SELECT A.dataID FROM udt_Data_Piece A, udt_Data_Roll B,MhnaUserFullSectInfo C,fullSectInfo D
WHERE 1=1 AND (1=1 AND B.key0=D.fullSectNum And C.fullSectNum = D.fullSectNum and C.USERID ='20041008171353037554'
AND C.tableID='20060614112532609227' AND C.tableType='ROLL' )
AND A.tableID='20060614170144593181' AND A.rollDataID = B.DataID AND A.GSFLAG = 'G'
AND ROWNUM<11