Re: Oracle Table Partitioning

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1996/12/12
Message-ID: <32AFCA13.6CBC@qrcsun.qrc.org>#1/1

Mike Rushton wrote:

> What are the performance increases like?
>
> Does the optimizer work as Oracle suggests (i.e. it only scans the tables needed
> to retrieve the data required and not all the tables)?
>
> What about Table constraints, do these need to be duplicated for every table?

For the constraints, it is required to duplicate it unless the constraints are specified for the partition.

For the performance, it may increase because each partition can use its own access method.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Thu Dec 12 1996 - 00:00:00 CST