AW: VERY strange query plan (LONG)

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Oleg Bartunov'" <oleg(at)sai(dot)msu(dot)su>
Cc: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: AW: VERY strange query plan (LONG)
Date: 2000-08-10 08:14:42
Message-ID: 11C1E6749A55D411A9670001FA687963368046@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2000-08-10 08:41:13 Re: AW: VERY strange query plan (LONG)
Previous Message Stephan Szabo 2000-08-10 04:49:34 Re: CREATE INDEX test_idx ON test (UPPER(varchar_field)) doesn't work...