Re: count(*) ?
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 17 Jan 2008 11:58:48 +0100
Message-ID: <cdbf0$478f34e8$524b5c40$1540@cache4.tilbu1.nb.home.nl>
>
> 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.
Date: Thu, 17 Jan 2008 11:58:48 +0100
Message-ID: <cdbf0$478f34e8$524b5c40$1540@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 upReceived on Thu Jan 17 2008 - 04:58:48 CST