Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: join & views
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