Re: How do I speed this up?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sun, 8 Dec 2002 17:59:46 -0000
Message-ID: <3df393bd_3@mk-nntp-1.news.uk.worldonline.com>

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:3df25697$0$236$cc9e4d1f_at_news.dial.pipex.com...
> "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.
>

<snip>

Absolutely correct, Niall. That's why I said logically. OP may need to look again at the physical design.

Regards,
Paul Received on Sun Dec 08 2002 - 11:59:46 CST