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: <artmt_at_hotmail.com>
Date: 23 Jan 2007 13:56:17 -0800
Message-ID: <1169589377.627766.202220@v45g2000cwv.googlegroups.com>

Valentin Minzatu wrote:
> What happens if you index it?

It still accesses both tables, except that for one of them it uses the index. Received on Tue Jan 23 2007 - 15:56:17 CST

Original text of this message

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