Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Views hints
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. Received on Fri Jun 15 2007 - 09:09:48 CDT
![]() |
![]() |