Re: How to improve this query?

Hi!

Thanks for your reply.

> If all you want to test for is not null and your column is indexed then
you
> should use
> select count(*)
> from table
> where col is not null;

I have been told, that there is no difference between count(*) and count(1). Is that right?

Thomas Received on Mon Nov 24 2003 - 07:55:10 CST