Re: [SQL] indexes - Mailing list pgsql-sql

From Heiko Wilms
Subject Re: [SQL] indexes
Date
Msg-id 3752A811.40AC6471@stud.fh-hannover.de
Whole thread Raw
In response to Re: [SQL] indexes  (Remigiusz Sokolowski <rems@gdansk.sprint.pl>)
Responses Re: [SQL] indexes
List 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@stud.fh-hannover.de





pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] indexes
Next
From: Tom Lane
Date:
Subject: Re: [SQL] indexes