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: Optimizing Queries Against UNIONed View

Re: Optimizing Queries Against UNIONed View

From: MTNorman <mtnorman_at_duke-energy.com>
Date: 22 Jan 2007 13:46:13 -0800
Message-ID: <1169502373.126855.310870@s34g2000cwa.googlegroups.com> 






artmt_at_hotmail.com wrote:


> Is there a way (other than a meterialized view) to make sure it goes

> directly to the CODE_TYPE2 table?




Try adding a check constraint to each table that limits the value of
code_type, then the optimizer will "see" only the table with the
code_type you want...



check (code_type = 'CODE_TYPE1')  to the first table
check (code_type = 'CODE_TYPE2')  to the second table
Received on Mon Jan 22 2007 - 15:46:13 CST












Original text of this message













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