Ada beberapa cara untuk menggabungkan table menggunakan Hint :
1. USE_NL
(untuk menggabungkan table dengan nested loop join)
ex:
SELECT /*+ USE_NL(b a)*/
a.col1, b.col1, a.col2
FROM table1 a, table2 b
WHERE a.col1 = b.col1;
2. USE_MERGE
(untuk menggabungkan table menggunakan sort-merge join)
ex:
SELECT /*+ USE_MERGE(b a)*/
a.col1, b.col1, a.col2
FROM table1 a, table2 b
WHERE a.col1 = b.col1;
3. USER_HASH
(penggabungan table menggunakan hash join)
SELECT /*+ USE_HASH(b a)*/
a.col1, b.col1, a.col2
FROM table1 a, table2 b
WHERE a.col1 = b.col1;
4. DLL (masih banyak lagi d:/ )
lutfi hedir <[EMAIL PROTECTED]> wrote:
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 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.
---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
[Non-text portions of this message have been removed]
--
-----------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/
