Re: Convert table into partitioned table (Fast)

From: joel garry <joel-garry_at_home.com>
Date: Fri, 7 Mar 2008 12:51:56 -0800 (PST)
Message-ID: <b221e775-4dc8-44d9-98b7-1ba732e0aa6a@e10g2000prf.googlegroups.com>


On Mar 7, 2:53 am, "Shakespeare" <what..._at_xs4all.nl> wrote:
> <mc..._at_hotmail.com> schreef in berichtnews:d515e7d1-9d16-48ea-b804-dbc6f26b2d15_at_e23g2000prf.googlegroups.com...
>
> >> do a bunch of insert to
> >> select froms into tables with appropriate where clauses, and exchange
> >> each of those for partitions. Not that I've ever tried it.
>
> >That sounds like a great idea.....  That way I can do all of the
> >loading into the tables up front, and then do the partition exchange
> >during the outage window.
> >Thanks very much
>
> You may be missing some records if they were inserted into the table between
> the up front loading and the partition exchange.... but if this is not the
> case, or not relevant, it may be worth while to try...
>
> Shakespeare

True - but he did say date range partitioning strategy. Of course, he could use a different strategy like insert into ... select from... where... for all but the last partition, if he just has to put the last partition during the window... as always, the best performance comes from not doing something while checking the performance, even if outside that window it's molasses. Assuming sufficient space.

jg

--
@home.com is bogus.
http://catless.ncl.ac.uk/Risks/25.07.html#subj13 Duhhhhhhh...
Received on Fri Mar 07 2008 - 14:51:56 CST

Original text of this message