Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Viewed Partitions
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