Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I speed this up?
"Mike Heden" <mheden_at_bigfoot.com> wrote in message
news:53b3de4.0212071108.2326c6e4_at_posting.google.com...
> Paul,
>
> No they're not the same table, although you could be forgiven for
> thinking that was the case. Both tables contain other columns that
> are particular to the individual table. It's just the uniquekey
> column that is common to both. Normally the rows in thses two tables
> always have a couterpart row with the same uniquekey value in the
> other table. I need to remove rows where there is no matching entry
> in the other table.
I think that what Paul was getting at was that if both tables have the same key, and the same set of records should be found in both tables, then from a design point of view they should not be two tables but one.
As far as your question goes you may well find that not exists works better than not in.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Sat Dec 07 2002 - 14:14:13 CST