X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id B9CC9475EBD
	for <pgsql-sql@postgresql.org>; Fri,  7 Feb 2003 03:11:42 -0500 (EST)
Received: from klingon.netkonect.net (klingon.netkonect.co.uk [194.62.44.61])
	by postgresql.org (Postfix) with ESMTP id DA3D1475E2B
	for <pgsql-sql@postgresql.org>; Fri,  7 Feb 2003 03:04:30 -0500 (EST)
Received: from cheetah.webtribe.net (cheetah.webtribe.net [194.164.194.4])
	by klingon.netkonect.net (8.11.4/8.11.4) with ESMTP id h1784JN17549
	for <pgsql-sql@postgresql.org>; Fri, 7 Feb 2003 08:04:19 GMT
Received: from localhost (cheetah.webtribe.net [194.164.194.4])
	by cheetah.webtribe.net (Postfix) with SMTP id 2131718332
	for <pgsql-sql@postgresql.org>; Fri,  7 Feb 2003 08:04:20 +0000 (GMT)
Cc: 
Subject: which will be faster? w/ or w/o indices
Content-type: text/plain
X-mailer: WebMail 
Date: Fri, 7 Feb 2003 08:04 +0000
Mime-version: 1.0
To: pgsql-sql@postgresql.org
From: val@webtribe.net
Message-Id: <20030207080420.2131718332@cheetah.webtribe.net>
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/139
X-Sequence-Number: 11537

I understand that if you are importing data into the database=20
that this will go faster if there are no indices against the=20
target table.

If I want to run this statement:
INSERT INTO table_a SELECT * from table_b WHERE value_1 BETWEEN=20
X AND Y;
is it best to do that with or without indices?

AND, if I want to run this statement:
DELETE FROM table_B WHERE value_1 BETWEEN X AND Y;
is it best to do that with or without indices?


We are using v 7.2.1 on a Sun E4500.

TIA,
val