AW: VERY strange query plan (LONG)

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: VERY strange query plan (LONG)
Дата
Msg-id 11C1E6749A55D411A9670001FA687963368046@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список pgsql-hackers

> very strange numbers and no indices used) (I did run vacuume analyze)
> 
> explain
> select
>         txt.tid
> from
>         txt, txt_lexem1 tl1_0, txt_lexem11 tl11_0
> where
> tl1_0.lid =17700
> OR
> tl11_0.lid =172751
> ;
> NOTICE:  QUERY PLAN:

Did you forget to join the tids together, and the did=0 restrictions ?

Your statement looks very strange (cartesian product), and has nothing in 
common with the subselect statements you quoted.

Andreas


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

Предыдущее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: AW: VERY strange query plan (LONG)
Следующее
От: Kaare Rasmussen
Дата:
Сообщение: Re: Arrays and foreign keys