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
>
>
>
>
>
Received on Fri Jul 03 1998 - 07:49:58 CDT
