RE: Count(*) not doing a FTS??
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Sep 2004 07:48:43 -0400
Not sure and I'm nowhere near ready to kick those particular tires, but if
you have computed statistics in 10g+, never shut down any way but
consistently, and you are running some combination of AWR, AMT, and/or ADDM
it might be the case that Oracle can definitely know the number of rows from
summary information.
If Graham or someone who actually knows is lurking he may want to comment.
Frankly I cannot remember whether this was speculation of something that
might be possible with dynamic statistics collection or something that was
either implemented or slated to be implemented. If something like that is
there, presumably we would start seeing new stuff popping out in Wolfgangs
(10053). I haven't come across anything like that in the FMs yet, but I'm
mostly looking at installation stuff at this point.
On Thu, 2 Sep 2004, rjamya wrote:
> I am sitting in a class and instructor told us that count(*) reads
> rowcount from segment header in some (or most?) cases ...
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
