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
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To read recent messages -

Other related posts: