Count(*) not doing a FTS??

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 2 Sep 2004 11:20:58 -0400
Message-ID: <9177895d04090208207368b7bc@mail.gmail.com>

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_at_freelists.org&subject=unsubscribe To read recent messages - http://freelists.org/archives/oracle-l/09-2004 Received on Thu Sep 02 2004 - 18:24:27 CDT