Count(*) not doing a FTS??

From: rjamya <rjamya@xxxxxxxxx>
To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 2 Sep 2004 11:20:58 -0400

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

Follow-Ups:

Re: Count(*) not doing a FTS??
From: Wolfgang Breitling

Re: Count(*) not doing a FTS??
From: Ganesh Raja

Re: Count(*) not doing a FTS??
From: Daniel W. Fink

Re: Count(*) not doing a FTS??
From: Steve Rospo

Count(*) not doing a FTS??

Other related posts: