From: | Pavel Mamin <pm(at)sky(dot)ru> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | |
Date: | 1999-09-15 10:11:50 |
Message-ID: | 3674.990915@sky.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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=<some value>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Molnár László | 1999-09-15 10:55:27 | trees in postgres |
Previous Message | Joerg Eriskat | 1999-09-15 08:53:10 | SELECT DISTINCT and ORDER BY |