Oracle 9.2.0.3.0
HP-UX 11i
block size 16K
db_file_multiblock_read_count 64
I have five groups of tables that have the same
query issued to them.
Table structures, indexes
are the same, just the data and the number of rows
are different. The
three tables that have more
than 3 million rows
Bill,
Try this:
Delete
From T1
Where F1 In
(
Select F1
From T1
Minus
Select PK
From T2
);
This will delete T1 rows for which there's no matching PK in T2 and will
most likely be quicker than the Not Exists query, though you never can say
for sure! ;-)
Oh, and the Cost that Explain