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

From: Alvar Freude <alvar(dot)freude(at)merz-akademie(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: What's faster: value of 0 or NULL with index
Date: 2000-12-11 03:28:24
Message-ID: 3A3449D8.9DC899AD@merz-akademie.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)freude(at)merz-akademie(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message GH 2000-12-11 04:06:24 Re: What's faster: value of 0 or NULL with index
Previous Message Tom Lane 2000-12-11 01:23:58 Re: Re: Re: Why PostgreSQL is not that popular as MySQL ?