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>



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

Original text of this message