導(dǎo)讀:1建站知識(shí)因?yàn)樵贔OR .. IN () LOOP 游標(biāo)中使用 所以不能采用下面的查詢語(yǔ)句做游標(biāo)如何seo優(yōu)化推廣網(wǎng)站seo網(wǎng)站優(yōu)化。

復(fù)制代碼 代碼如下:

select a.f_username from ( SELECT /*+parallel(gu,4)*/distinct gu.f_username FROM t_base_succprouser gu where gu.f_expectenddate > (select trunc(sysdate,'Y')FROM DUAL) and gu.f_lotid=1 and gu.f_playid=4 and gu.f_paymoney>=1500 ) A left join ( select from t_base_vip_customes and ((vu.f_passeddate is null ) or (vu.f_passeddate > trunc(sysdate,'Y') )) and ((vu.f_lotid is null ) or (vu.f_lotid=1)) and ((vu.f_playid is null ) or (vu.f_playid=4)) and ((vu.f_condtionid is null ) or (vu.f_condtionid=3)) )B on A.f_username=B.f_usernam where b.f_username is null

采用下面的語(yǔ)句 只能查出部分用戶

復(fù)制代碼 代碼如下:

SELECT /*+parallel(gu,4)*/distinct gu.f_username FROM t_base_succprouser gu left join t_base_vip_customes VU on gu.f_username=vu.f_username gu.f_expectenddate > (select trun網(wǎng)站建設(shè)c(sysdate,'Y')FROM DUAL) and gu.f_lotid=rec_viplotplay.f_lotid and gu.f_playid=rec_viplotPlay.f_Playid and gu.f_paymoney>=rec_viplotPlay.F_Conditon_ValuesA and ((vu.f_passeddate is null ) or (vu.f_passeddate > trunc(sysdate,'Y') )) and ((vu.f_lotid is null ) or (vu.f_lotid=rec_viplotplay.f_lotid)) and ((vu.f_playid is null ) or (vu.f_playid=rec_viplotPlay.f_Playid)) and ((vu.f_condtionid is null ) or (vu.f_condtionid=rec_viplotPlay.F_CondtionID)) and vu.f_username is null

執(zhí)行計(jì)劃：

復(fù)制代碼 代碼如下:

SELECT STATEMENT, GOAL = ALL_ROWS HASH UNIQUE NESTED LOOPS OUTER PARTITION RANGE ALL TABLE ACCESS FULL Object name=T_BASE_SUCCPROUSER VIEW FILTER TABLE ACCESS FULL Object name=T_BASE_VIP_CUSTOMES FAST DUAL

后來(lái)改成了下面就能全部查出來(lái)了

復(fù)制代碼 代碼如下:

SELECT /*+parallel(gu,4)*/distinct gu.f_username FROM t_base_succprouser gu left join t_base_vip_customes VU on gu.f_username=vu.f_username and ((vu.f_passeddate is null ) or (vu.f_passeddate > trunc(sysdate,'Y') )) and ((vu.f_lotid is null ) or (vu.f_lotid=rec_viplotplay.f_lotid)) and ((vu.f_playi公司網(wǎng)站建設(shè)d is null ) or (vu.f_playid=rec_viplotPlay.f_Playid)) and ((vu.f_condtionid is null ) or (vu.f_condtionid=rec_viplotPlay.F_CondtionID)) where gu.f_expectenddate > (select trunc(sysdate,'Y')FROM DUAL) and gu.f_lotid=rec_viplotplay.f_lotid and gu.f_playid=rec_viplotPlay.f_Playid and gu.f_paymoney>=rec_viplotPlay.F_Conditon_ValuesA and vu.f_username is null 執(zhí)行計(jì)劃： SELEC營(yíng)銷型網(wǎng)站建設(shè)T STATEMENT, GOAL = ALL_ROWS HASH UNIQUE FILTER NESTED LOOPS OUTER TABLE ACCESS BY GLOBAL INDEX ROWID Object name=T_BASE_SUCCPROUSER INDEX RANGE SCAN Object name=IX_BASE_PROUSER_LOWEX FAST DUAL VIEW TABLE ACCESS FULL Object name=T_BASE_VIP_CUSTOMES

oracle 不懂先把數(shù)據(jù)給過(guò)濾掉然后在來(lái)連接嗎？ 太笨了！而且這樣把符合條件的數(shù)據(jù)也過(guò)濾掉了相關(guān)如何seo優(yōu)化推廣網(wǎng)站seo網(wǎng)站優(yōu)化。

關(guān)鍵詞標(biāo)簽: 標(biāo)題 標(biāo)簽