Hi All,

My requirement is to fetch the previous day records.Iam joining three tables hereby.I used the below queries,but the DB2 cost seems to be high.Is there any simpler way to reduce the db2 cost and optimize the query further?

Query:
-----
Iam selecting around ten fields and below is my where condition,

Query:1
--------

Code:
FROM     ARJ00T.ARJAUTH
...