Re: wrong results from "Select count(*) from tbl"

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 16 Jul 2003 22:44:21 GMT
Message-ID: <9zkRa.38$206.9@news02.roc.ny>

"John Muller" <john.muller_at_bankofamerica.com> wrote in message news:270abe86.0307161054.3d162072_at_posting.google.com... --snip--
> One of our DBAs suggested the problem has somehting to do with
> the indexes and not running analyze on the table recently.
> I'll note also that the table is partitioned.
>
> I think it's Oracle version 8.x running on a Sun box.
>
> Has anyone seen this before or does anyone have any
> suggestions on the cause of the problem.
>
> Thanks,
>
> - john

Is your DBA on crack <g>
Can you show this by running it in sqlplus and cut paste the results here. You seem to have written the example from your memory (as Daniel also mentions).

Anurag Received on Wed Jul 16 2003 - 17:44:21 CDT