[Q] analyze-command, speeding up, sort_area_size?
Date: 1997/03/12
Message-ID: <3326B348.367A_at_ibm.net>#1/1
Hi,
When recreating indexes i use a special version of initxx.ora with
sort_area_size set to 64000000. This helps a lot.
I figured, that sinze the analyze command uses the temp-area, it could
perhaps benefit from a large sort_area_size.
Any knowledge/experience concerning this matter would be a great help.
LONGER VERSION:
I would like to do it tonight, but my window for the operation is only 3
hours. I tried analyzing one of my large tables with a sample of just 1
percent. It took 4 minutes, so I hope I can find a way to speed things
up.
TIA
Regards
SHORT VERSION:
Is there a way to speed up the analyze command!
I need to analyze about 2GB of data (+ 2GB of indexes) using the command
analyze table xxx estimate statistics sample 10 percent.
Jens Wartenberg
WARTENBERG | People
Industri Data - Denmark | that make a difference
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
IBM RS/6000 - IBM AIX - Oracle | For industrial needs
-------------------------------------------------------------
Received on Wed Mar 12 1997 - 00:00:00 CET