RE: how determine chaining if using gather_stats

[Jeffrey Beckstrom]

from the docs, it states it does not compute chained row count. >>> [EMAIL PROTECTED] 6/1/01 10:00:26 AM >>> Hi Jeffrey, If you've decided to use dbms_stats, I don't know the reasons to use analyze anymore. In terms of stored statistics DBMS_STATS will give you the same and a little more. I mean for example integral statistics for your partition tables. And you can analyze tables in parallel Regards, Ed -----Original Message----- Sent: 1 ???? 2001 ?. 16:55 To: Multiple recipients of list ORACLE-L Since oracle seems to be pushing the dbms_stats.gather_stats procedure for getting table statistics.  Do you run a separate analyze command to find the number of chained rows since gather stats does not get this value.  Or are you still using "analyze". Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard   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).