Обсуждение: what index is faster to scan

Поиск
Список
Период
Сортировка

what index is faster to scan

От
Adam Radłowski
Дата:
Hello!
I'm thinking about two things:
1. what index is faster to scan (for select ... where statements) unique
or not unique ?
2. can the unique index to slow inserts commands (in comparison with not
unique index) ?
Best regards
Adam

Re: what index is faster to scan

От
Adam Radłowski
Дата:
Sorry for question. I've tested it by myself. There is no significant
differences.
Adam

Adam Radłowski napisał(a):
> Hello!
> I'm thinking about two things:
> 1. what index is faster to scan (for select ... where statements) unique
> or not unique ?
> 2. can the unique index to slow inserts commands (in comparison with not
> unique index) ?
> Best regards
> Adam
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>