prasad
Its not the utc.get_local_date that is causing the full table scan - its the query.
If you look for a particular date in the Order_release table, it will scan all entries unless you add an index on the field being searched.
Adding further filtering criteria would help reduce the number of records to scan (if available).
Cheers
Gary
