SQL - Any data in this column?

I want to check a ceratin column to see if it has any data for a certain ID. So I'm using this SQL:

SELECT count(mycolumn)
FROM mytable
WHERE myid = 10
AND mycolumn IS NOT NULL

If that returns a number greater than zero I know there is data in the column. However, for my situation this is too slow. Is there a faster way?

Cheers,

elziko Received on Thu Jan 23 2003 - 07:28:47 CST