RE: Forever running Analyze

<FONT face=Arial color=#0000ff
size=2>Couldn't you try and estimate about 50% of it?  It's not as reliable, but it would probably work.
<FONT face=Arial color=#0000ff
size=2>Kev

<FONT face=Tahoma

  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Kevin LangeSent:   Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list   ORACLE-LSubject: Forever running Analyze   Hi
  folks;
<FONT face=Arial color=#0000ff

  size=2>  We have an Analyze running that is taking forever.  Here is   the setup:
<FONT face=Arial color=#0000ff

  size=2>    The table is about 250 bytes   wide.
<FONT face=Arial color=#0000ff

  size=2>    The table is normally 100,000   rows
<FONT face=Arial color=#0000ff

  size=2>    The table has grown to over 4,000,000   rows.
<FONT face=Arial color=#0000ff

  size=2>    There is one index on 1 column.
<FONT face=Arial color=#0000ff

  size=2>    <FONT
  face=Arial color=#0000ff size=2>We used the Compute Statistics   options
<FONT face=Arial color=#0000ff

  size=2> 
  Does
  anyone have any suggestions on how we can get this analyze to complete and   still generate worthwile statistics ??
<FONT face=Arial color=#0000ff

  size=2> 
<FONT face=Arial color=#0000ff

  size=2>Thanks
<FONT face=Arial color=#0000ff

  size=2> 
<FONT face=Arial color=#0000ff

  size=2>Kevin Received on Tue Jun 12 2001 - 16:14:35 CDT