RE: Forever running Analyze

I am hoping that things might work. This is one of our posibilities tonite. I have just always stayed clear of Estimating statistics. But, thanks for the numbers. I will consider it.

Kevin

-----Original Message-----
Sent: Tuesday, June 12, 2001 4:34 PM
To: ORACLE-L_at_fatcity.com; kgel_at_ppoone.com

Hi Kevin,
 I use estimate stats with sample 30 percent with some of the large tables (~ 60,000,000 rows). Generated stats are okay. It completes in about 2-3 hours (8.0.6 and 8.1.7 databases).
 Have you considered estimating stats rather than computing?

 HTH,  Regards,

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Kevin Lange [SMTP:kgel_at_ppoone.com]
> Sent: Tuesday, June 12, 2001 4:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Forever running Analyze
>
> Hi folks;
> We have an Analyze running that is taking forever. Here is the setup:
> The table is about 250 bytes wide.
> The table is normally 100,000 rows
> The table has grown to over 4,000,000 rows.
> There is one index on 1 column.
> We used the Compute Statistics options
>
> Does anyone have any suggestions on how we can get this analyze to
> complete and still generate worthwile statistics ??
>
> Thanks
>
> Kevin

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: kgel_at_ppoone.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).