Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Viewed Partitions

Viewed Partitions

From: David Horlacher <davidhorlacher_at_sprintmail.com>
Date: 1997/01/18
Message-ID: <32E0C0BF.2ACB@sprintmail.com>#1/1

I am trying to implement partitioned views in 7.3 running on NT 3.5. I have defined my partitioned tables as recommended in the concepts manual using check constraints and then defining a view that unions all the partitions. I have also received and followed an oracle bulletin that describes a checklist for implementing partitioned views.

When I select count(*) from my partitioned view where the partition_column = 'value', the optimizer still scans all the physical underlying tables.

Has anyone implemented partitioned views successfully? Received on Sat Jan 18 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US