multiple key indices vs single key

From: admin <admin(at)wtbwts(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: multiple key indices vs single key
Date: 1999-12-16 11:35:48
Message-ID: Pine.BSF.4.10.9912161132060.3479-100000@server.b0x.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When using a btree index, the manual says I can specify up to 7 keys in a
single multi-column index. Is there any difference between calling a
single index with 7 keys and calling 7 indices with 1 key each, btree in
both cases? In which instances should a btree index use only a single key?
Where could I have found this information in the online manual (read
chapter 7. Indices and Keys of the User's Guide).

Thanks again,
Marc

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Teege 1999-12-16 11:58:21 Long pg_log and pg_time
Previous Message Fabian.Frederick 1999-12-16 11:05:42 RE: [GENERAL] Installation problem on Suse linux 6.3