Re: Count(*) not doing a FTS??

Rowcount on the Segment Header .... Not heard abt that ... Wont it be
a Major Overhead updating that for Every Row Inserted ... ???

Ganesh

On Thu, 2 Sep 2004 11:20:58 -0400, rjamya <rjamya@xxxxxxxxx> wrote:
> I am sitting in a class and instructor told us that count(*) reads
> rowcount from segment header in some (or most?) cases rather than
> doign the good ol' FTS. He can't remember exact details, so this email
> ....
> 
> is it true? Which version was this introduced? Someone has a
> reproducible test case?
> 
> Thanks in advance
> Raj
> ------------------------------
> ---
> To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
> To read recent messages - http://freelists.org/archives/oracle-l/09-2004
>
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

Other related posts: