Antw: [SQL] query with subquery abnormally slow?

>>> Oskar Liljeblad <osk(at)hem(dot)passagen(dot)se> 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