On Sun, 23 Nov 2003 15:18:13 +0100, "Tom Miskiewicz"
<miskiewicz2_at_yahoo.com> wrote:
>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
>
Please do NOT (I repeat NOT!!!) CROSS- and MULTIPOST to every group
you can spell. The small group of people responding here monitor all
three groups. I've just responded your identical query in .server and
it seems like you are waisting time and bandwith.
--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Nov 24 2003 - 03:35:52 CST
