Query otimizing possible?

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
****************************************************************

Browse pgsql-sql by date

  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