query tuning

Hi All,

What needs to be done if query is doing INDEX RANGE SCAN ?

Indexes are there already in place.ALso one of the materialize biew is going for full scan.

MAT_VIEW ACCESS FULL           | MV_ID_TO_REGION_LOOKUP |    89 |  1068 |       |     2   (0)| 00:00:01 |       |

Predicate Information (identified by operation id):
---------------------------------------------------

  12 - access("B"."Ir_br"="T2"."ID")
  19 - access("NMRSTOP">=TO_DATE(TO_CHAR(SYSDATE@!-7,'mm/dd/yyyy')||'12:00:00 AM','mm/dd/yyyy hh:mi:ss am'))
  21 - access("A"."ID"="B"."ID")

Rgards