[prasad]

We are using utc.get_local_date function very frequently. Is there a better way to get the local date? This function call is taking a long time execute.

For example.

to_char(ORD.LATE_PICKUP_DATE,'DD-MON-YYYY') = '14-MAR-2008' (ORD is order release)

This condition in the where clause scans through all the rows in the order release ID.
How can I avoid the complete table scan?

Thanks,
Prasad.