Hi,
I am facing problem with the following query .It is taking a lot of execution time.I need help with tuning this query.
Query:
SELECT
A,
B,
C,
D,
E
FROM
QUAL1.TABLE1
WHERE
PROCS_TIMSTM > = TIMESTAMP (?) AND
PROCS_TIMSTM < = TIMESTAMP (?) AND
AGENT_CD = ? AND
( STORE_CD IN (?, ?, ?, ?) OR DLV_STORE_CD...