Multi-column Indexes. What is best Conan? - Mailing list pgsql-general

From Rodney McDuff
Subject Multi-column Indexes. What is best Conan?
Date
Msg-id 199903100317.NAA01227@its.uq.edu.au
Whole thread Raw
Responses Re: [GENERAL] Multi-column Indexes. What is best Conan?
List pgsql-general
Hi
    When you have a table with multiple columns and you want indexes on
them you can either
(a) create index table_idx on table using btree ( col1, col2, ..., col7);

or
(b) create index table_col1_idx  on table using btree ( col1 );
    create index table_col2_idx  on table using btree ( col2 );
    .
    .
    .

But what is best?


pgsql-general by date:

Previous
From: M Simms
Date:
Subject: Database out of sync
Next
From: dustin sallings
Date:
Subject: Re: [GENERAL] Multi-column Indexes. What is best Conan?