RE: Analyze with estimate

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Tue, 4 Jul 2000 15:03:34 +0300
Message-Id: <10548.111166@fatcity.com>

When you analyze table, following tables get updated.

DBA_TABLES
DBA_INDEXES
DBA_TAB_COLUMN

And when you analyze index, two more table get updated and those are - INDEX_STAT
INDEX_HISTOGRAM HTH. Sandeep.
Riyadh, Saudi Arabia.

	-----Original Message-----
	From:	Dan.Hubler_at_midata.com [SMTP:Dan.Hubler_at_midata.com]
	Sent:	Tuesday, July 04, 2000 2:08 AM
	To:	Multiple recipients of list ORACLE-L
	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.

        ?????????

	-- 
	Author: 
	  INET: Dan.Hubler_at_midata.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).

Received on Tue Jul 04 2000 - 07:03:34 CDT