Query otimizing possible?
| От | Andreas Schmidt |
|---|---|
| Тема | Query otimizing possible? |
| Дата | |
| Msg-id | 35E2DC13.E273AF6@uni-tuebingen.de обсуждение |
| Список | 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.schmidt@uni-tuebingen.de * URL : http://www.jura.uni-tuebingen.de/~ifk/index.html ****************************************************************
В списке pgsql-sql по дате отправления: