Search notes:
Oracle SQL Plan operation: DELETE STATEMENT
The
plan operator DELETE STATEMENT is one of the
root operations and when not executed in parallel always has exactly one row source which is
DELETE.
drop table tq84_tab;
create table tq84_tab (
id integer,
grp varchar2(3),
val number
);
begin
insert into tq84_tab values (1, 'AAA', 7);
insert into tq84_tab values (2, 'AAA', 12);
insert into tq84_tab values (3, 'AAA', 5);
insert into tq84_tab values (4, 'BBB', 2);
insert into tq84_tab values (5, 'CCC', 21);
insert into tq84_tab values (6, 'CCC', 18);
insert into tq84_tab values (7, 'CCC', 3);
end;
/
explain plan for
delete from
tq84_tab
where
val > 15
;
select * from table(dbms_xplan.display(format=>'basic'));
--
-- ---------------------------------------
-- | Id | Operation | Name |
-- ---------------------------------------
-- | 0 | DELETE STATEMENT | |
-- | 1 | DELETE | TQ84_TAB |
-- | 2 | TABLE ACCESS FULL| TQ84_TAB |
-- ---------------------------------------