Kerry wrote:
> Is the reason it performs so poorly because you're repeating the use of
> the 'A' table, and so created a correlated sub-query? What if you recoded
> it like this:
>
> delete from A
> where ID not in
> (select A2.ID from A A2, B
> where B.A_ID=A2.ID)
Filed for when I next test <g>.
cheers,
peter
============================================
Peter Hyde, SPIS Ltd, Christchurch, New Zealand
* Print-to-Web automation http://TurboPress.com
* Web design, automation and hosting specialists
* TurboNote: http://TurboPress.com/tbnote.htm
-- small, FREE and very handy
Find all the above and MORE at http://www.spis.co.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
