Received: from unixserv.rz.fh-hannover.de (root@rzgw.rz.fh-hannover.de
	[141.71.1.10]) by hub.org (8.9.3/8.9.3) with SMTP id LAA03534
	for <pgsql-sql@postgreSQL.org>; Mon, 31 May 1999 11:24:28 -0400 (EDT)
	(envelope-from wilms@stud.fh-hannover.de)
Received: from schering.si2.uni-hannover.de by unixserv.rz.fh-hannover.de (AIX
	3.2/UCB 5.64/4.03) id AA25231; Mon, 31 May 1999 17:30:46 +0200
Sender: wilms@unixserv.rz.fh-hannover.de
Message-Id: <3752A811.40AC6471@stud.fh-hannover.de>
Date: Mon, 31 May 1999 17:17:38 +0200
From: Heiko Wilms <wilms@stud.fh-hannover.de>
Organization: Schering-Institut
X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.35 i586)
X-Accept-Language: en
Mime-Version: 1.0
To: "pgsql-sql@postgreSQL.org" <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] indexes
References: <Pine.GS4.4.02A.9905311102450.26326-100000@netra.gdansk.sprint.pl>
	<37527870.9ACEAB28@krs.ru>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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