Re: Partitioned views vs. partitioned tables

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Wed, 13 Jan 1999 17:08:25 +0800
Message-ID: <369C6289.42E7@bhp.com.au>

Philip Button wrote:
>
> Hi
>
> Does anyone have any views on the merits or otherwise of partitioned views
> vs. partitioned tables ... the specific environment is Oracle 8.0.3,
> Windows NT, on a DEC alpha .... the partitions would be monthly data added
> to a data warehouse table ....
>
> Thanks
>
> Phil

My understanding is that partitioned tables (on O8) are basically the same as partition views (available since O7) with the added benefit of not having your ins/upd/del scripts needing to know about the partitioning...

Go with partition tables...
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Wed Jan 13 1999 - 03:08:25 CST