查詢挺慢的，看看有什么優(yōu)化空間：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