Hi,

I have three tables and I have a big batch of delete
job going to run:

create table temp (col1 number, co12 number, col3
number)
unique index on temp1(col1,col2)

create table temp2 (col1 number, co12 number, col3
number)
index on temp2(col1)

create table temp3 (col1 number, co12 number, col3
number)
index on temp3(col1)

query:
(A)
delete from temp where (col1, col2) in
(select col1, 1 from temp2 minus
select col1, 1 from temp3)

vs
(B)
delete from temp where col1 in (
select col1 from temp1 minus
select col1 from temp2) and col2 = 1


Which query will be more efficient? Is (B) more
efficient than (A)?

benny

__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
Oracle LazyDBA home page