On Tue, 11 Mar 2008, Bill Moran wrote:
> In response to "Robins Tharakan" <tharakan@gmail.com>:
>> Sorry, if I am missing something here, but shouldn't something like this
>> allow us to get a (fast) accurate count ?
>>
>> SELECT COUNT(*) from table WHERE indexed_field IS NULL
>> +
>> SELECT COUNT(*) from table WHERE indexed_field IS NOT NULL
>
> For certain, qualified definitions of "fast", sure.
And certain, qualified definitions of "accurate" as well. Race condition?
Matthew
--
"Television is a medium because it is neither rare nor well done."
-- Fred Friendly