which will be faster? w/ or w/o indices

From: val(at)webtribe(dot)net
To: pgsql-sql(at)postgresql(dot)org
Subject: which will be faster? w/ or w/o indices
Date: 2003-02-07 08:04:00
Message-ID: 20030207080420.2131718332@cheetah.webtribe.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

If I want to run this statement:
INSERT INTO table_a SELECT * from table_b WHERE value_1 BETWEEN
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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Weaver 2003-02-07 08:10:29 "function has no parameter $1" - help.
Previous Message waimeng 2003-02-07 07:53:18 PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "."