Re: [SQL] query with subquery abnormally slow?

Поиск
Список
Период
Сортировка
От Oskar Liljeblad
Тема Re: [SQL] query with subquery abnormally slow?
Дата
Msg-id 19991101200528.A7338@oskar
обсуждение исходный текст
Ответ на query with subquery abnormally slow?  (Oskar Liljeblad <osk@hem.passagen.se>)
Список pgsql-sql
On Mon, Nov 01, 1999 at 07:47:07PM +0100, Oskar Liljeblad wrote:
> 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:

Ok, I should have read the latest FAQ and checked the mail
archive before posting this.

I've read about the EXISTS-workaround, but it seems it can't be
applied to my query because it deals with one table only.
Or can it?

Oskar Liljeblad (osk@hem.passagen.se)




В списке pgsql-sql по дате отправления:

Предыдущее
От: Oskar Liljeblad
Дата:
Сообщение: query with subquery abnormally slow?
Следующее
От: "Moray McConnachie"
Дата:
Сообщение: Re: [SQL] query with subquery abnormally slow?