Re: Better Delete method
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 12 Jul 2021 02:25:21 +0300
Message-ID: <CAOVevU71CFiNKEXVBB5BBu=z5KMy1xwHMTyo5kg226ofUNQ6EQ_at_mail.gmail.com>
Date: Mon, 12 Jul 2021 02:25:21 +0300
Message-ID: <CAOVevU71CFiNKEXVBB5BBu=z5KMy1xwHMTyo5kg226ofUNQ6EQ_at_mail.gmail.com>
Hi all,
11.2 is too old... You should really consider an upgrade to currently
supported versions.
I like the new 12.2+ "alter table ... move including rows where ..."
feature:
https://blogs.oracle.com/sql/how-to-delete-millions-of-rows-fast-with-sql
--
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 12 2021 - 01:25:21 CEST