Re: Using INDEX hint against a view

No, you definitly need to put the hint when you select from the view. I know this from painful experirence !

On 3 Jul 1998 12:49:58 GMT, "Pavel Polcar" <pavel.polcar_at_berit.cz> wrote:

>Hi,
>I think that you could try to put the hint in the view DEFINITION, not when
>you select from the view. It's just a
>suggestion, I haven't tried it.
>HtH,
>--
>Pavel Polcar
>
>gary&lilia <gary_and_lilia_at_email.msn.com> wrote in article
><e0tazSjp9GA.275_at_upnetnews02.moswest.msn.net>...
>> Using Oracle 7.3, is it possible when selecting against a view to use the
>> INDEX hint against the underlying table of the view? I tried it and it
>> didn't work, but I do not have any prior experience with hints.
>> Unfortunately, our application only selects data from views (because of
>> other considerations, e.g. security).
>>
>> Thanks for any help,
>> Gary H
>>
>>
>>
>>
>>

MarK Z, 6b, rhymingly Received on Wed Jul 08 1998 - 10:18:58 CDT