That's what the doc says. However, at least with Oracle 8.0.5 through
8.1.7.2.0 on Solaris, if you do not explictily compute statistics, the
NUM_ROWS column in DBA_TABLES and DBA_INDEXES has a decimal value. (yup the
table has 32.345 rows in it.)
This may not seem like a big deal until you try to tune the queries that
reference these tables/indexes. Man, do the exectution plans get screwed up
(how about a FTS against a 5million row table in a nested-loops operation!)
I've submitted a TAR on this and am "working with" Oracle support.
Kevin
-----Original Message-----
Sent: Wednesday, June 13, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L
On Tuesday 12 June 2001 15:05, Kevin Kostyszyn wrote:
> Couldn't you try and estimate about 50% of it? It's not as reliable, but
> it would probably work.
Actually, Oracle will do a 'compute statistics' when you attempt to do
an 'estimate statistics' on 50% or more.
Jared
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Toepke, Kevin M
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
