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

Other related posts: