Chris,

Here is view query ,

select /*+ INDEX(FD_TABLE) */ df_num,col2,col3, col4
from fd_table
where test_date between to_date('18-JAN-2001','DD-MON-YYYY') and to_date('17-FEB-2001','DD-MON-YYYY')


The above hint we put when local index was there on the table and it is still there with global index.

thanks