Received: from eba-haus.de ([149.228.241.94]) by hub.org (8.9.3/8.9.3) with SMTP id BAA97681 for ; Tue, 2 Nov 1999 01:50:04 -0500 (EST) (envelope-from DieringG@eba-haus.de) Received: from kopo001 by eba-haus.de;Tue, 02 Nov 1999 06:45:45 GMT with Novell_GroupWise; Tue, 02 Nov 1999 07:45:45 +0100 Message-Id: X-Mailer: Novell GroupWise 5.5 Date: Tue, 02 Nov 1999 07:45:31 +0100 From: "Gerhard Dieringer" To: Subject: Antw: [SQL] query with subquery abnormally slow? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id BAA97866 >>> Oskar Liljeblad 01.11.1999 19.47 Uhr >>> >>I'm doing a SELECT query with a subquery on a table with 12K rows >>but it is very slow (10 seconds+). The query looks like this: >> >> select * >> from items >> where package in >> (select package >> from items >> where ...blah... >> group by package) >> ..... I am sorry if I am still sleeping and don't see the problem, but what is the difference between this querry and the following: select * from items where ...blah... Gerhard