Ok Thanks Padahal udah saya pecah menurut tahun.... mungkin harus dipecah menurut bulan kali ya :D Untuk commitnya paka ada pengaruh jika jalan lsg atau nanti??
________________________________ From: Hardi Tandiono <[email protected]> To: [email protected] Sent: Thu, June 10, 2010 7:43:43 AM Subject: Re: [indo-oracle] Normal Query LAMA? untuk query delete akan makan waktu lebih lama. ada baiknya querynya di pecah dan dicommit setelah selesai. contoh --Delete from TABLE_NAME --Where FIELD <= To_date('20090131','YYYYMMDD') and FIELD >= To_date('20090131','YYYYMMDD'); commit; --Delete from TABLE_NAME --Where FIELD <= To_date('20090201','YYYYMMDD') and FIELD >= To_date('20090228','YYYYMMDD'); commit; dan seterusnya. ________________________________ From: bima boediman <[email protected]> To: [email protected] Sent: Thu, June 10, 2010 8:32:57 AM Subject: [indo-oracle] Normal Query LAMA? Para sesepuh.... Ane ada tabel isinya kurang lebih 700rb Records.... Terus ane jalanin SQL seperti ini : --Delete from TABLE_NAME --Where FIELD <= To_date('2009','YYYY') tapi udah 1jam 15 menit kok belum kelar ya?? apakah Normal atau ada yang ga beres? Mohon INPO please.... [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
