Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: join & views
No, and there is no reason to do that. While some RDBMS's create a
temporary table when one issues a select against a view, Oracle does not do
this. Instead it merges the view definition and the query on the view thus
transforming the query you sent it into another query.(basically rewriting
it) You should switch to the cost based optimizer.
Jim
"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 Mon Dec 17 2001 - 22:02:46 CST