INTERSECT / where id IN (etc..)

Поиск

Список

Период

Сортировка

От	James Cooper
Тема	INTERSECT / where id IN (etc..)
Дата	5 марта 2003 г. 19:54:52
Msg-id	003701c2e37a$fe0bb2d0$c900a8c0@jax обсуждение исходный текст
Ответы	Re: INTERSECT / where id IN (etc..)
Список	pgsql-sql

Greetings.

I was wondering if somone out there could shed some light on a query performance issie I have.

I have a large lookup table that I query with nested selects to gain the INTERSECT result from.

the bigger this table gets the slower the performance.

1. is creating a temp table and only intersecting from this a good idea?

2. does having a where clause in your select before your nested intersects change the amount of work the query

i.e. select person_id from person where person_id < 5000 And person_id IN

as opposed to

select person_id from person where person_id IN(etc)

thoughts?

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