From: Heiko Wilms <wilms@stud.fh-hannover.de>
To: pgsql-sql@postgreSQL.org <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] indexes
Date: Mon, 31 May 1999 17:17:38 +0200
Message-ID: <3752A811.40AC6471@stud.fh-hannover.de> (raw)
References: <Pine.GS4.4.02A.9905311102450.26326-100000@netra.gdansk.sprint.pl>
<37527870.9ACEAB28@krs.ru>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: wilms@stud.fh-hannover.de
Subject: Re: [SQL] indexes
In-Reply-To: <3752A811.40AC6471@stud.fh-hannover.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox