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]
