RE: Forever running Analyze

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: ktoepke_at_cms.cendant.com

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: ListGuru_at_fatcity.com (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).