SQL index tip

This where clause can be made more simple and avoid unnecessary formatting by Oracle if you use the default Oracle format for the date test. Sometimes function calls will cause Oracle to disregard the index.

This:
update rad.dcd10dm
...
where dep > to_date('03/20/2006', 'MM/DD/YYYY');

Can be coded like this:
update rad.dcd10dm
...
where dep > '20-mar-06';