Re: [GENERAL] What's faster: value of 0 or NULL with index

2000-12-11 Thread GH
On Mon, Dec 11, 2000 at 04:28:24AM +0100, some SMTP stream spewed forth: > 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

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

2000-12-10 Thread Alvar Freude
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 Al