IS (NOT) NULL

Hi!

I have a varchar2 column, that can be null and I need to use it in a count() query. What is the most efficient way to do it? Currently I'm doing it this way, but I'm not sure if there is a way to improve it.

SELECT COUNT(1) FROM mytable WHERE an_indexed_column = 0 and not_indexed_column IS NOT NULL;

Thanks
Tom Received on Sun Nov 23 2003 - 08:18:13 CST