Re: count(*) ?
Date: Thu, 17 Jan 2008 13:43:18 +0100
Message-ID: <478f4d64$0$85782$e4fe514c@news.xs4all.nl>
"Frank van Bortel" <frank.van.bortel_at_gmail.com> schreef in bericht
news:cdbf0$478f34e8$524b5c40$1540_at_cache4.tilbu1.nb.home.nl...
> shakespeare wrote:
>
>>>>
>>> mmm I must correct that, both views become invalid. Have seen examples
>>> of
>>> the contrary, will look them up and report....
>>>
>>>
>>> Shakespeare
>>>
>>
>> Got it.... in the pythian blogs:
>>
>> http://www.pythian.com/blogs/627/oracle-11g-unexpected-difference-between-count-and-count1
>>
>> and seems to be an 11g issue, does not reproduce in my 10g database.
>>
>> Shakespeare
>>
>>
> And that case has nothing to do with the counting, but
> with fine grained object dependency tracking.
>
> --
>
> Regards,
> Frank van Bortel
>
> Top-posting in UseNet newsgroups is one way to shut me up
That's what the comments on the article say, yes.
Shakespeare Received on Thu Jan 17 2008 - 06:43:18 CST