RE: Analyze with estimate

From: <mleith_at_bradmark.co.uk>
Date: Tue, 4 Jul 2000 9:40:14 +0100
Message-Id: <10548.111158@fatcity.com>

Straight from Advanced Oracle Tuning and Admin=2E=20=

The statistics can be viewed via DBA_TABLES, DBA_TAB_COLUMNS and DBA_INDEXES=2E=20= For example the Num_Rows column of DBA_TABLES displays the number of rows=20= within a table=2E

-----Original Message-----

From:	MIME :Dan=2EHubler_at_midata=2Ecom=20=
Sent:	Monday, July 03, 2000 11:14 PM
To:	ORACLE-L_at_fatcity=2Ecom
Subject:	Analyze with estimate

Can somebody tell me specifically which dictionary/catalog columns are updated when I
execute an "ANALYZE TABLE XXXXXXX ESTIMATE STATISTICS SAMPLE 10 PERCENT;"

Or (better yet) point me to the documentation that defined same?

Thanks=2E

?????????

• Author: INET: Dan=2EHubler_at_midata=2Ecom

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=2Ecom (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)=2E You may also send the HELP command for other information (like subscribing)=2E Received on Tue Jul 04 2000 - 03:40:14 CDT