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: join & views

Re: join & views

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Tue, 18 Dec 2001 18:38:51 -0800
Message-ID: <uffrv9.8p.ln@zstux.ita.pwr.wroc.pl>


Hi,

Didn't get your question? What do you want to achive in that approach. In any case your
explain plan is built on the tables (not on views) and it will be taken care by view merging phase

"Mark" <marbz_at_hotmail.com> wrote in message news:9vlrub$vk8$1_at_nreada.inwind.it...
> I have to make a query that is a join between tables and views.
> Is a way to tell the optimizer of not considering the views, but the
tables
> that makes the views?
> I use the rule based optimizer.
>
> Thanks in advance!
>
>
Received on Tue Dec 18 2001 - 20:38:51 CST

Original text of this message

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