Received: from box.sky.ru (sky-rtk1.sky.ru [195.161.194.222]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA50080 for ; Wed, 15 Sep 1999 06:12:32 -0400 (EDT) (envelope-from pm@sky.ru) Received: from pm.sky.ru (pm.sky.ru [195.161.194.26]) by box.sky.ru (8.9.3/8.9.3) with SMTP id QAA19378 for ; Wed, 15 Sep 1999 16:11:27 +0600 Date: Wed, 15 Sep 1999 16:11:50 +0600 From: Pavel Mamin X-Mailer: The Bat! (v1.33) UNREG / CD5BF9353B3B7091 Reply-To: Pavel Mamin X-Priority: 3 (Normal) Message-ID: <3674.990915@sky.ru> To: pgsql-sql@postgreSQL.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Please, help me. For example, I have a table > create table tab1 > (field1 int4 primary key, field2 int4, field3 int4); .. and I want to make the next query: > select field1, field2, field3 > from tab1 > where field2= > order by field3; What indexes I have to make? Either: > create index idx1 on tab1 (field2, field3); Or: > create index idx1 on tab1 (field2); > create index idx2 on tab1 (field3); Or something else? Pavel Mamin, Network Programmer, SkyNet Co. ISP, Yekaterinburg, Russia