Re: Count(*) not doing a FTS??
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 2 Sep 2004 11:52:34 -0700
AFAIK the segment header does not have a row count, only the number of blocks
below hwm. But on the matter of count(*) not doing a FTS, that is correct.
Oracle will use an index when possible.
Quoting rjamya <rjamya@xxxxxxxxx>:
> 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 - //freelists.org/archives/oracle-l/09-2004
>
--
regards
Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
