新手请教各位大侠~!
强制使用NESTED LOOPS的时候,几个表的嵌套顺序要什么规则么,比如语句这样写:
Select /*+use_nl(a b c d)*/
a.Svcnum, b.Rsrcid, c.Imsi, d.Subsvcid
From Ac_App_Yy.Tab_Subscrb a, Ac_App_Yy.Tab_Gsmsubscrb b, Ac_App_Yy.Tab_Sim c, Ac_App_Yy.Tab_Srvg d
Where a.Areaid = '074741' And b.Areaid = '074741' And a.Subscrbid = b.Subscrbid And b.Rsrctypeid = '2' And
Sysdate Between b.Begintime And Nvl(b.Endtime, Sysdate + 1) And c.Sim = b.Rsrcid And c.Svcid = '10' And
c.Areaid = '074741' And a.Subscrbid = d.Subscrbid And d.Areaid = '074741' And d.Svcid = '10' And
d.Removedate Is Null And d.Subsvcid = '000000310'
数据量都是百万以上,d 最大,其他相当
语句中/*+use_nl(a b c d)*/abcd的顺序和嵌套顺序有关系么?
|