Re: How do I speed this up?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sun, 8 Dec 2002 18:07:48 -0000
Message-ID: <3df393c0_3@mk-nntp-1.news.uk.worldonline.com>

"Mike Heden" <mheden_at_bigfoot.com> wrote in message news:53b3de4.0212071121.748d46ae_at_posting.google.com...
> Paul,
>
> Something I forgot to mention in my last reply...
>
> Your right - *logically* they could be the same table. Unfortunately,
> they're not. This is something that is used by a third-party
> application, and it relies upon this particular data structure, so I
> cannot change it.
>
> Regards,
>
> Mike
>

Mike,

I followed up Niall's post (above in my threading), before reading this one. Now I see the dreaded mention of "third-party application", and I sympathise. Sorry.
BTW: Not Peoplesoft, by any chance?

On to the performance issue, have you tried 'delete from tablea where pk_tablea in (select pk_tablea minus select pk_tableb from tableb)'?

Regards,
Paul Received on Sun Dec 08 2002 - 12:07:48 CST