Re: problems on views

Eitan wrote:
> Hello,
> I have created a view with some hints ( /*+ index ... etc... /*)
> I use this view on a report, with where statement clause.
>
> When I linked the view to another table like this :
> select ...
> from my_view, another_table
> where my_view.a_code = another_table.a_code
> and ....
>
> (the code is the index of other table,
> the extra where statement is the same as I use before joining to
> another_table).
>
> main problem is that hints doesn't work, and oracle use it's optimizer,
> which is not what I wanted.
>
> Thanks :)

No DDL.
No DML.
No version.
No trace.

I think the solution is blue.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)