Re: Viewed Partitions

David Horlacher wrote:
>
> 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?

Yes, but they are fairly buggy. I've got sundry problems which will be fixed in 7.3.3 and 7.3.4, with some backports to 7.3.2.3.

There is a bug in some versions where partitioning does not work on char columns, or integer columns if the constraint is an equality.

Just in case, though:

	the union must be (explicitly or implicitly)
	select * from t1 union all select * from t2 ....

	all tables must be created identically (same cols, same order)

	all indexes must match across all tables

---
Jonathan Lewis