Index on nullable column

From: "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Index on nullable column
Date: 2006-03-24 22:13:15
Message-ID: 1E293D3FF63A3740B10AD5AAD88535D201DA051D@UBIMAIL1.ubisoft.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

Is an index on a nullable column useful for retrieving rows having that
column null?

SELECT PlayerID
FROM PlayerLoginSession
WHERE EndTime IS NULL;

Regards,

--
Daniel CAUNE
Ubisoft Online Technology
(514) 4090 2040 ext. 5418

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2006-03-24 22:29:10 Re: SQL Query Newbie Help
Previous Message Amos Hayes 2006-03-24 21:34:43 Re: Find min and max values across two columns?