Database DataWarehousing (MOSC)

MOSC Banner

MINUS and DELETE

edited Dec 20, 2010 1:44PM in Database DataWarehousing (MOSC) 8 commentsAnswered ✓
Hi all,
Can someone tell me how oracle does minus operation? Is it a DML operation?

In data warehouse system, we are usually confronted with this kind of situations. To delete a great number rows from a much bigger data set.

For example, 10million rows should be removed from 10 Billion.

Let assume we can know or enumerate the rows that we should remove. I mean I can create the table
create table rows_to_delete nologging
as select /*+ parallel */ * from t where <filter condtions>;

Which is faster or more reasonable or more feasible of the following two method:

1. create table rows_to_keep nologging

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center