Salam Lagi, Format nya : select /*+ HINT */ field from table where ...
Contoh : select /*+ CHOOSE */ a.col1,b.col2 from a,b where ...... Mudah2an membantu, Hatur nuhun, Kiki Kuswara ----- Original Message ----- From: "lutfi hedir" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, February 08, 2005 2:28 PM Subject: [indo-oracle] hint optimizer for joint table > > Salam > > Temen2 indo -oracle sy mau tanya gimana menggunakan > hint optimizer untuk query join table > > contoh > > select a.col1,b.col2 > from a,b > where ...... > > index table a = aidx > index table b = bidx > > terimakasih > > lutfi hedir > > ________________________________________________________________________ > Yahoo! India Matrimony: Find your life partner online > Go to: http://yahoo.shaadi.com/india-matrimony > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > > > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
