From: | Andreas Schmidt <andreas(dot)schmidt(at)uni-tuebingen(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Query otimizing possible? |
Date: | 1998-08-25 15:45:24 |
Message-ID: | 35E2DC13.E273AF6@uni-tuebingen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
I am workíng with Postgres95, and querys like
select * from lit_b where i1='n78' or il='ng798' or il='k45'
works very slow. There is an index on il, but it is obviously
used only when there is only one il='dd69' statement. For
example the time for doing the query increases from 3 seconds
to 3 minutes when using 2 il='dd69' statements. In this case the
class seems to be searched sequently.
Does anybody know a workaround for this Problem?
Thanks in advance
Andreas
--
****************************************************************
* Andreas Schmidt
* Institut fuer Kriminologie
* Corrensstr. 34
* 72076 Tuebingen/Germany
* Telefon: +49 -7071-72040
* Fax : +49-7071-65104
* e-mail : andreas(dot)schmidt(at)uni-tuebingen(dot)de
* URL : http://www.jura.uni-tuebingen.de/~ifk/index.html
****************************************************************
From | Date | Subject | |
---|---|---|---|
Next Message | Brook Milligan | 1998-08-25 17:20:18 | Re: [SQL] parts of date_part() |
Previous Message | Jose David Martinez Cuevas | 1998-08-25 15:22:14 | Re: [SQL] copy probs |