Re: How to pass bind variable value into a view

From: UXDBA <unixdba73_at_googlemail.com>
Date: Fri, 9 Oct 2009 00:12:03 -0700 (PDT)
Message-ID: <cd5059ad-b0db-489a-9d2e-ad502f97748c_at_x37g2000yqj.googlegroups.com>

On Oct 8, 9:58 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
>   > You could hint your query to use the index on t2.col2. There is a
> way to
>
> > 'push' the hint to the view, can't exactly remember how though.
>
> > Shakespeare
>
> Me too, but i could remember, where i've seen it ;-)http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/hintsr...
>
> Best regards
>
> Maxim

I tried hint. But its not helping in my case. I can do hint this way:

create or replace view V1
(col1,col2)
as
select /*+HINT_NAME*/
as select col1,col2 from t1 where col3=?

regards. Received on Fri Oct 09 2009 - 02:12:03 CDT