Coba pakai hint seperti ini -- Query select /*+ Index(table_name c) */ field_name from table_name
-- Insert kalau insert tdk perlu pakai index karena insert tidak memerlukan fungsi pencarian mudah2an bisa membantu. Kiki Kuswara -----Original Message----- From: FARHAN VALERIE [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 2:49 PM To: [email protected] Subject: [indo-oracle] Cara pakai index Hi all, Saya punya tabel yg punya index bbrp misalnya a,b,c. Bagaimana carannya menggunakan salah satu dari index tsb misalnya utk insert harus index a, untuk query index c, dsb. Farhan --------------------------------- 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 -- -----------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/
