Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Why doesnt partiotining elimination work?

Why doesnt partiotining elimination work?

From: TT-Boy <MarcBier_at_Rocketmail.com>
Date: Mon, 02 Aug 1999 21:44:44 +0200
Message-ID: <37A5F52B.A240C0FA@Rocketmail.com>


First I do this..

a) create table a1 as select * from old_a where year = 1998
b) create table a2 as select * from old_a where year = 1999
c) create view v_a as select * from a1 union select * from a2
d) create check contraint on a1 (year = 1998)
e) create check contraint on a2 (year = 1999)
f) create primary keys on a1.year and a2.year

If I do...
Select * on v_a where year = 1999

The explain plan show that I access both tables a1 and a2; Why?
Oracle does partiotining elimination when having check contraints or not???
Help!!
Thanks
Marcus Received on Mon Aug 02 1999 - 14:44:44 CDT

Original text of this message

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