Hi,

I need help with this:

select T.TRM from BS_IDX I, BS_TRM T
where (I.COD_BASE = ? and I.COD_GRP = ?) and T.COD = I.COD_TRM
group by T.TRM
plan join (I INDEX (FK_BS_IDX_COD_GRP), T INDEX (PK_BS_TRM))

The index for T.TRM column is BS_TRM_TRM_IDX. How to add this index to PLAN
clause ?

Thanks,

Rafael Santini