Parallel Delete - DML

[Nikee]

Hello,

I would like to delete approx. 15 Miilion records from a single partition table (nonpartitioned table).

Can I run a parallel DML delete statement to get rid of all the records from a table?

Thanks,
Nikee

[jmodic]

Originally posted by Nikee
Can I run a parallel DML delete statement to get rid of all the records from a table?

If you want to get rid of *all of your records* from a table, then what's the point in using DML delete statement at all? Why not simply using TRUNCATE istead? Uncomparable faster and it resets the HWM on the table at the same time.

[tamilselvan]

Yes. You can do parallle delete on unpartitioned table.

The steps I used in 9i are:

Alter session enable parallel query;

Alter session enable parallel dml;

alter table table_A parallel 6;

delete from table_A where colA = 'xxxx';

commit;

alter table table_A noparallel;

Tamil

[Nikee]

Hello Tamilselvan,

Thanks for the response.

How about nologging option? I have already turned off the Archive log mode.

At this point, will the nologging option is useful?
Or nologging is good only in the archive mode?

Thanks,
Nikee

[abhaysk]

Why dont u take Jurij's suggestion?????


Well even if you may want to retain 25% of Rows then insert into some temp table the desired recs and truncate main table.. then insert back the reocords from temp table. ( with all those parallel, nologging, noindexes and all that stuff )

[tamilselvan]

NOLOGGING is no effect with delete operation.

Tamil