Re: SQL challenge;-)

From: Frank an der Heiden <fh_at_energotec.de>
Date: Thu, 3 May 2001 09:53:37 +0200
Message-ID: <9cr2qt$q28$1@oxygen.technet.net>

hehehe,

yes, it WAS too late.
thank u

--
MfG / Best Regards

Frank an der Heiden
ESA - Energotec Systeme und Automation GmbH
Tel: +49 (0)211 91440-19
Fax:+49 (0)211 669343
email: fh_at_energotec.de
"I came, saw and installed everything new!"


"Drazen Kacar" <dave_at_arsdigita.com> schrieb im Newsbeitrag
news:9cq24k$n4l$1_at_news1.transmedia.de...


> Frank an der Heiden wrote:

>

> > this sql-statement works:

> >

> > SELECT <column> FROM <table1> WHERE <column> NOT IN (SELECT <column>

 FROM


> > <table2>);

> >

> > but it is very very slow, because the second select is done very often

 if


> > you have many rows in table1.

> > any simple idea for improving performance?

>

> select column from table1

> minus

> select column from table2;

>

> --

>  .-.   .-.    Sarcasm is just one more service we offer.

> (_  \ /  _)

>      |        dave_at_arsdigita.com

>      |

Received on Thu May 03 2001 - 02:53:37 CDT