Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to improve this query?
Hello!
I want to count those records in a table, where the field I specified is not empty. How to make such a query efficient. Is there a different/more efficient way to achieve that, then select count(1) from mytable where myfield != NULL? Myfield is a varchar2 field. I'm using Oracle 9.
Thanks
Thomas
Received on Fri Nov 21 2003 - 08:17:22 CST