bener, stl saya tambah inde di kol (gl_code,sl_code,curr_code), performance
nya nambah , tadinya 20 menit jadi 8 menit.
btw, utk lebih mengimprove lagi, bagaimana ya?
tia
--null
----- Original Message -----
From: "Tomi Wijanto" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, April 24, 2006 10:13 AM
Subject: Re: [indo-oracle] server lemot
> Bukankah kolom yg saya maksud adalah
> (gl_code,sl_code,curr_code) di-posting saya
> sebelumnya?
> Apabila index tsb bisa membatasi secara signifikan
> hasil dari led_detail, akan sangat bagus.
>
> Sedangkan index yg ada kolom seq_no akan dipakai utk
> mengakses led_head (seq_no adalah PK dari leg_head
> kan?).
>
> regards,
> tomi
>
Send instant messages to your online friends http://asia.messenger.yahoo.com
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
YAHOO! GROUPS LINKS
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
