SQL & PL/SQL

Hi,

If I want to use hints in PL/SQL procedure, it is valid to write it this way:

begin
 update /*+  INDEX(opp DIM_OPP_REFDB_IDX) */
        scott.rec_dim_opportunity opp
        set opp.mp_opportunity_re ....
end

I doubt when I tried it that the optimizer didn't actually use the index.

Thanks in advance.

Oracle 10g R1
Windows 2003 32-bit