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 -> Re: partition

Re: partition

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 20 Feb 2007 13:49:53 -0800
Message-ID: <1172008193.875180.127140@v45g2000cwv.googlegroups.com>


On Feb 20, 4:37 pm, "James" <jwilk..._at_gmail.com> wrote:
> Hi,
>
> I have a view that joins two partitioned (range) tables. They have
> the same partition key - quarter of the year.
>
> The view looks like this:
> create view my_view as(
> select a.id, a.name, a.quarter, b.id, b.name, b.quarter
> from tab1 a, tab2 b
> where a.id = b.id(+) and a.quarter = b.quarter(+))
>
> And I am invoking the view like this:
> select * from my_view where quarter = 4
>
> Due to the outter join, Oracle always scans all 8 partitions from both
> tables. What do I have to do to get it to realize that I am only
> asking for the data of the forth quarter and use the proper
> partition? Thanks!
>
> James.

Have you tried specifying PARTITION clause in your query? Received on Tue Feb 20 2007 - 15:49:53 CST

Original text of this message

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