Re: Views hints

From: Rodrigo De León <rdeleonp_at_gmail.com>
Date: Fri, 15 Jun 2007 14:21:14 -0000
Message-ID: <1181917274.365264.268480@q75g2000hsh.googlegroups.com>

On Jun 15, 9:09 am, joker197cin..._at_gmail.com wrote:
> Is there a way to force index use in a view that involves 2 or more
> tables?
>
> I would like to do this:
>
> select /*+ INDEX(PK_TAB_INDEX) */ * from my_view:
>
> where PK_TAB_INDEX is an index in one of the tables involved in view.
>
> I tried but hint simply seems ignored.
>
> Any help appreciated, regards.

See: http://www.dbasupport.com/oracle/ora9i/CBO6_1.shtml

Search for "Using Hints in Views". Received on Fri Jun 15 2007 - 09:21:14 CDT