What's faster: value of 0 or NULL with index

Поиск
Список
Период
Сортировка
От Alvar Freude
Тема What's faster: value of 0 or NULL with index
Дата
Msg-id 3A3449D8.9DC899AD@merz-akademie.de
обсуждение исходный текст
Ответы Re: What's faster: value of 0 or NULL with index  (GH <grasshacker@over-yonder.net>)
Список pgsql-general
Hi,

I'm thinking about, what might be faster on SELECTs: a column with index
which is NOT NULL and takes the value of 0 or a column which can take
the NULL value instead of 0, also with index.

My feeling sais, that 0 and NOT NULL should be a lot more faster, but
perhaps it's not true?


bye
  Alvar


--
Alvar C.H. Freude  |  alvar.freude@merz-akademie.de

    Demo: http://www.online-demonstration.org/  |  Mach mit!
Blast-DE: http://www.assoziations-blaster.de/   |  Blast-Dich-Fit
Blast-EN: http://www.a-blast.org/               |  Blast/english

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: Re: Why PostgreSQL is not that popular as MySQL ?
Следующее
От: GH
Дата:
Сообщение: Re: What's faster: value of 0 or NULL with index