Re: How to pass bind variable value into a view
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 08 Oct 2009 22:58:57 +0200
Message-ID: <4ACE5291.7000808_at_gmail.com>
> 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
Date: Thu, 08 Oct 2009 22:58:57 +0200
Message-ID: <4ACE5291.7000808_at_gmail.com>
> 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/hintsref.htm#i27644
Best regards
Maxim Received on Thu Oct 08 2009 - 15:58:57 CDT