Re: performance on delete the rows from a huge table

You might also look at asktom.oracle.com, search for difference in performance between not in and not exists. Like http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:953229842074

I also wonder about your select *.

If you expect a substantial percentage of rows to be deleted you might consider doing a CTAS of the ones you want to keep, then a rename.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20050319/news_1b19oracle.html