Received: from mx02.uni-tuebingen.de (root@mx02.uni-tuebingen.de [134.2.3.12]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA11762 for ; Tue, 25 Aug 1998 05:45:57 -0400 (EDT) Received: from uni-tuebingen.de (pc13.ifk.jura.uni-tuebingen.de [134.2.81.13]) by mx02.uni-tuebingen.de (8.8.8/8.8.8) with ESMTP id LAA28375 for ; Tue, 25 Aug 1998 11:45:38 +0200 Message-ID: <35E2DC13.E273AF6@uni-tuebingen.de> Date: Tue, 25 Aug 1998 11:45:24 -0400 From: Andreas Schmidt X-Mailer: Mozilla 4.04 [en] (Win16; I) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Query otimizing possible? Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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.schmidt@uni-tuebingen.de * URL : http://www.jura.uni-tuebingen.de/~ifk/index.html ****************************************************************