Re: Better Delete method

From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
To: Jonathan Lewis <jlewisoracle@xxxxxxxxx>
Date: Mon, 12 Jul 2021 02:25:21 +0300

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

References:
- Better Delete method
  - From: Lok P
- AW: Better Delete method
  - From: ahmed.fikri@xxxxxxxxxxx
- Re: Better Delete method
  - From: Lok P
- AW: Better Delete method
  - From: ahmed.fikri@xxxxxxxxxxx
- Re: Better Delete method
  - From: Lok P
- Re: Better Delete method
  - From: Jonathan Lewis

Other related posts:

» Better Delete method- Lok P
» Re: Better Delete method- Juliano Ribeiro
» RE: Better Delete method- Mark W. Farnham
» Re: Better Delete method- Andrew Kerber
» Re: Better Delete method- Mladen Gogala
» Re: Better Delete method- Lok P
» Re: Better Delete method- Lok P
» Re: Better Delete method- Jonathan Lewis
» Re: Better Delete method- Lok P
» Re: Better Delete method- Mladen Gogala
» Re: Better Delete method- Jonathan Lewis
» Re: Better Delete method- Jonathan Lewis
» Re: Better Delete method- Rich J
» Re: Better Delete method- Jonathan Lewis
» Re: Better Delete method - Sayan Malakshinov
» Re: Better Delete method- Lok P
» Re: Better Delete method- Jonathan Lewis