有个表80W的表和8w多表做链接有优化空间吗？

Question

查询挺慢的，看看有什么优化空间：select (SELECT'裝卸說明:'||BC.LOADING_DESC||' CY電話'||BC.TELFROM TM_BOOKING_CONTAINER TBC,TM_BOOKING TB,BK_CONTAINER BCWHERE EXISTS (SELECT 1 FROM ST_FEEDER_CTN_LINK FL WHERE FL.ST_FEEDER_ID=SF.ST_FEEDER_ID AND TBC.BK_CONTAINER_ID=FL.BK_CONTAINER_ID)AND TBC.TM_BOOKING_ID=TB.TM_BOOKING_IDAND TBC.BK_CONTAINER_ID=BC.BK_CONTAINER_IDAND TB.BUSIENSS_TYPE='VCY'AND ROWNUM=1)AS LOADING_DESC_CY_TEL,SF.OTHER_REMARK,SF.OCEAN_VESSEL_CODE||'/'||SF.OCEAN_VOYAGE AS OCEAN_VVL,SF.OCEAN_POL_NAMEFROM ST_FEEDER SFLEFT JOIN ST_FEEDER_GLOBAL SFG ON SFG.ST_FEEDER_ID=SF.ST_FEEDER_ID AND SFG.GLOBAL_TYPE='TW'WHERE SF.ST_FEEDER_ID IN (SELECT COLUMN_VALUE FROM TABLE(F_STR2TYTABLE('0000000068fbc36d016903bd0bd20169', ',')))select count(*) from TM_BOOKING_CONTAINER;--654935select count(*) from TM_BOOKING;--652019select count(*) from BK_CONTAINER;--8043211

Answer 1

最好把执行计划发出来，才能进行进一步分析。

Answer 2

从sql语句看，建议把AS LOADING_DESC_CY_TEL的子查询，转换到表连接语句中。