Re: select count(*)

I've just remembered that I wrote a note about this a few months ago.

    http://www.jlcomp.demon.co.uk/testing_02.html

Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

• Original Message ----- From: "Sarma Aryasomayajula" <avnsarma_at_hotmail.com> To: <jonathan_at_jlcomp.demon.co.uk>; <oracle-l_at_freelists.org> Sent: Friday, October 06, 2006 5:05 PM Subject: Re: select count(*)

> Hi Jonathan,
>
> Thank you very much for answer and you are right, in predicate section it
> says null is not null.
>
> I did the explain plan but I am not sure wether I can attach here or not?
>

--
http://www.freelists.org/webpage/oracle-l