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

Поиск
Список
Период
Сортировка
От val@webtribe.net
Тема which will be faster? w/ or w/o indices
Дата
Msg-id 20030207080420.2131718332@cheetah.webtribe.net
обсуждение исходный текст
Ответы Re: which will be faster? w/ or w/o indices  (dev@archonet.com)
Список 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




В списке pgsql-sql по дате отправления:

Предыдущее
От: Michael Weaver
Дата:
Сообщение: "function has no parameter $1" - help.
Следующее
От: "waimeng"
Дата:
Сообщение: PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "."