is ANALYZE TABLE useful before CREATE INDEX ?

From: Andreas Wizemann <AWizemann_at_fvvag.de>
Date: Wed, 14 Nov 2001 19:57:02 +0100
Message-ID: <hk35vtc3t1b0tb408o1olpss828sr9k0k0@4ax.com>

Hi,
i have a job A creating a table, filling it with SQL*Loader and the creating some indexes.
For some reasons i can not modify job A. I have also created a job B creating some more indexes e.g. BITMAP Indexes. This job does a ANALYZE TABLE before creating the additional indexes. Then it does a ANALYZE INDEX on the newly build index.

Is this right order ?
Does a CREATE INDEX benefit from an analyzed table ? Or will it be better to create ALL indexes before running the ANALYZE TABLE, as it automatically sets also the statistic values for the indexes ?

Regards
Andreas

Andreas Wizemann Received on Wed Nov 14 2001 - 12:57:02 CST