RE: analyze indexes

On Mon, 15 May 2000, George.Brennan_at_warnermusic.com wrote:
> 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

George,

You're correct, and that's exactly how we have it partitioned currently (I'd hate to see performance if this was one big honkin table :). A direct-path load should work fine, but it continues to cause problems :( C'est la vie, I suppose, and it's something I'll be looking deeper into after the next monthly batch cycle runs.

Thanks,
GC

-- 
There is something inherently wrong with the world when Bill Gates is a
famous billionaire and Dennis Ritchie lives in relative obscurity.