...

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