Hi
folks;
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 - 15:23:47 CDT
