problems on views

From: Eitan <no_spam_please_at_nospam_please.com>
Date: Thu, 22 Dec 2005 15:05:52 +0200
Message-ID: <doe89i$nnn$1@news2.netvision.net.il>

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 :) Received on Thu Dec 22 2005 - 07:05:52 CST