UNIQUE constraint and indexing

Поиск
Список
Период
Сортировка
От Arcady Genkin
Тема UNIQUE constraint and indexing
Дата
Msg-id r1zpu8cfeqt.fsf@bashful.cdf.toronto.edu
обсуждение исходный текст
Ответы Re: UNIQUE constraint and indexing
Re: UNIQUE constraint and indexing
Список pgsql-general
Is the index, created implicitely by "UNIQUE" constraint, the same
kind as created explicitely with "CREATE INDEX"?  In other words,
is the following piece of SQL redundant?

create table foo (
       bar serial primary key,
       baz text not null unique );
create index foo_baz_idx on foo(baz);

Many thanks,
--
Arcady Genkin
i=1; while 1, hilb(i); i=i+1; end

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

Предыдущее
От: Dominique Dumortier
Дата:
Сообщение: PostGres is not using indices in select, I would like it to because it is too slow !
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: How to make a REALLY FAST db server?