Kalau begitu mah, coba atuh yang ini : SELECT /*+ INDEX(a aidx) INDEX(b bidx) */ a.col1,b.col2 From a,b where ......
Mudah2an terjawab Hatur nuhun, Kiki Kuswara -----Original Message----- From: lutfi hedir [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 4:03 PM To: [email protected] Subject: Re: [indo-oracle] hint optimizer for joint table terimakasih masalah-nya bukan sekedar pakainya, tapi bagaimana supaya index kedua tabel tersebut dipakai sehingga tidak terjadi full scan --- Kiki Kuswara <[EMAIL PROTECTED]> wrote: --------------------------------- 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 SponsorADVERTISEMENT document.write(''); --------------------------------- 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 the Yahoo! Terms of Service. ________________________________________________________________________ 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/
