Analyze estimate with 10% sample, alternatively analyze compute during
off-hours, if possible. Most of my "million row" club tables get maintained only
on weekends, or in pre-scheduled intervals.
Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144,
ext 5529
-----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
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