Re: Performance problem in view joining UNION ALL three tables
- From: Juan Carlos Reyes Pacheco <jcdrpllist@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Jul 2014 20:13:23 -0400
The option in oracle 7 was partitioning if some of you are new, and of
course I don't know if is useful in 11g.
http://docs.oracle.com/cd/A57673_01/DOC/server/doc/A48506/partview.htm
:)
2014-07-08 20:11 GMT-04:00 Juan Carlos Reyes Pacheco <jcdrpllist@xxxxxxxxx>:
> Hello, If you please have some advice.
> I have standard edition 11.2.0.3
>
> and I have view, like a primitive partitioning
>
> This is an old topic
>
> https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:21547067945222
> buty maybe there is a new trick on 11g.
>
> the view is like
> view a
> is
> select date,* from table_01ene1990_01ene2000
> union all
> select date,* from table_02ene2000_01ene2010
> union all
> select date,* from table_02ene2010_today
>
> I will like to know if there is some trick to get only access to the
> table,
> where the date is,
>
>
>
> In some situations I did it using a function table, the function table
> only query the specific table.
> But in other, like joinings I can't do that.
>
> The only I remember from oracle 7 an option I saw was outdated.
>
> Thank you.
>
>
>
>
>
>
Other related posts:
