RE: partitioned Views - Union All
- From: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
- To: <chaganti.suresh@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Aug 2007 14:16:17 -0500
Partitioned views are the way to go if you have a check constraint in
place for each union all, and IF the optimizer works as it is supposed
to. When I worked with them, I could never get the pruning to work as
it was supposed too. YMMV
Pat
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Suresh Chaganti
Sent: Thursday, August 23, 2007 12:55 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: partitioned Views - Union All
Hello
I may have to move some historical data to a different database, while
retaining flexbillity to query on demand.
Partitioned Views seem to be perfect option with UNION ALL views where
the optimizer is smart about not going to remote DB if it doesnt need
to.
But I am concerned about Rule Set for Union All view which practically
defeats the whole purpose.
More confusing is Oracle's statement to use partitioned Tables starting
from Oracle 8 instead of Partition views. In the scenario I described
above, obviously partitioned view is the way to go.
Here is the link for any one interested
http://download-west.oracle.com/docs/cd/A58617_01/server.804/a58246/dist
rib.htm#8451
Has any one implemented this feature. Please respond with any tips,
hidden parameters
thanks
Suresh
___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is
intended for use only by the individual or entity to which it is addressed, and
may contain information that is private, privileged, confidential or exempt
from disclosure under applicable law. If you are not the intended recipient or
it appears that this mail has been forwarded to you without proper authority,
you are notified that any use or dissemination of this information in any
manner is strictly prohibited. In such cases, please delete this mail from your
records.
To view this notice in other languages you can either select the following link
or manually copy and paste the link into the address bar of a web browser:
http://emaildisclaimer.medtronic.com
Other related posts:
