Re: [SQL] indexes

From: Heiko Wilms <wilms(at)stud(dot)fh-hannover(dot)de>
To: "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] indexes
Date: 1999-05-31 15:17:38
Message-ID: 3752A811.40AC6471@stud.fh-hannover.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

indices speed up database queries. Tell me if I'm wrong.
Does it make sense to create indices on all fields involved in
a query? If so, what is the best access method (btree,rtree,hash)?

Heiko

--
H. Wilms

Homepage schering.si2.uni-hannover.de/hugo
email wilms(at)stud(dot)fh-hannover(dot)de

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-05-31 15:20:06 Re: [SQL] indexes
Previous Message Vadim Mikheev 1999-05-31 11:54:24 Re: [SQL] indexes