RE: Forever running Analyze

[Kevin Kostyszyn]

Couldn't you try and estimate about 50% of it?  It's not as reliable, but it would probably work.

Kev

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin Lange
Sent: Tuesday, June 12, 2001 5: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