RE: analyze indexes

Gregory,

This table looks like a prime candidate for partitioning.

Maybe 12 * 1 month tables, should give 4~5 million rows per partition. It's a lot quicker working with 4~5 million rows.

George

> -----Original Message-----
> From: "Gregory Conron" <gconron_at_hfx.andara.com>
> [mailto:gconron_at_hfx.andara.com]
> Sent: Saturday, May 13, 2000 12:45 AM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: analyze indexes
>
>
> 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.
> --
> Author: Gregory Conron
> INET: gconron_at_hfx.andara.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon May 15 2000 - 04:01:24 CDT