Quick question - after a direct path load into a table via
sqlloader, we re-create the indexes (we have had problems leaving
the indexes on in the past during direct loads) and then analyze
the table and indexes to gather statistics.
However, re-creating the indexes takes way too long (55+million
row table - about 4 hours to rebuild the indexes), so we are
going to switch to a conventional path load and leave the
indexes on. My question is should the analyze step be left in,
or can it be removed since the indexes aren't being dropped?
Thanks,
GC
--
There is something inherently wrong with the world when Bill Gates is a
famous billionaire and Dennis Ritchie lives in relative obscurity.
Received on Fri May 12 2000 - 17:39:54 CDT
