Re: ORACLE 8.1.5.i : Strange problem with SELECT COUNT(*) WHERE ... IS NULL

the index doesn't store null value, so your select statement will never go through your index to count. Your problem may be caused by the table itself.

John Chiu
johnymc_at_netscape.net

Genoud wrote:

> I save the rows in a temp table, drop and recreate the table, reinsert the
> saved rows and recreate the index...
> Now it works again...
> Strange ...
>
> Mario Bucsics a écrit dans le message
> <03aa077e.8c092907_at_usw-ex0102-010.remarq.com>...
> >
> >Hi
> >
> >
> >I don´t know if this works but you could try it:
> >
> >select count(etat) from table_name where etat is null;
> >
> >
> > Mario Bucsics
> >
> >* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
> *
> >The fastest and easiest way to search and participate in Usenet - Free!
> >
Received on Wed Sep 22 1999 - 05:30:14 CDT