The hint syntax is correct (I've witnessed the change in plan on SQLab).
>Is this allowed:
>select /*+ INDEX(tab1 index1) INDEX(tab2 index2) */
> MAX(NVL(loc,'0'))
> from tab1, tab2
> where tab1.field = tab2.field
> and tab1.field = tab2.field;
>Will this work???? It may not be as fast as hashing, if you've got that
turned on, but I expect it to have good response. In a similar query I
included the ORDER hint to make the driving table the LEFT-MOST table (ORDER
goes left to right).
Received on Tue Apr 21 1998 - 20:23:11 CDT
