Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I speed this up?
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.
Regards,
Mike
"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:<3df11886$2_1_at_mk-nntp-1.news.uk.worldonline.com>...
> "Mike Heden" <mheden_at_bigfoot.com> wrote in message
> news:53b3de4.0212060743.56c83fc4_at_posting.google.com...
> > I have two tables which use a common unique key.
> >
> Why?
>
> Surely, logically they are the same table?
>
> Regards,
> Paul
Received on Sat Dec 07 2002 - 13:08:44 CST