Re: Challenge: Partitioning is a wrong idea

From: <fitzjarrell_at_cox.net>
Date: 8 Apr 2005 10:48:14 -0700
Message-ID: <1112982494.115459.121590@o13g2000cwo.googlegroups.com>

MBPP wrote:
> Another scenario where partition is good. We have a data warehouse
> database with many fact tables loaded daily from more than 100
> companies worldwide. One of the tables is an "item" table where the
PK
> is COMPANY_CODE and ITEM_CODE. We partitioned the table by company
and
> after we load, check and tranform the data sent by a specific company
> in a temporary table (with the same structure) we just exchange this
> table with the specific company partition (ALTER TABLE ... EXCHANGE
> PARTITION). It takes just 1/100 second, minimum availability
> interruption, minimal lock, etc.

Both are excellent replies, however neither is an absolute, a condition stated by the OP. Of course, there are no absolutes in partitioning, a concept the OP has failed repeatedly to grasp.

David Fitzjarrell Received on Fri Apr 08 2005 - 12:48:14 CDT