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: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 23 Jan 2007 14:18:55 -0800
Message-ID: <1169590735.634030.143550@d71g2000cwa.googlegroups.com> 





I do not think you can stop accessing both tables, but I do not see why
it would do FTS on any of them - I tried your scenario and it does use
indexes on both tables. The only way I can think of not to access both
tables would be to use list partitioning, but that is an option to the
enterprise edition (additional money for the license).
Received on Tue Jan 23 2007 - 16:18:55 CST












Original text of this message













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