By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,227 Members | 1,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,227 IT Pros & Developers. It's quick & easy.

Db2 query taking more execution time

P: 1
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 IN (?, ?, ?, ?) ) WITH UR;

thanks in advance
Oct 11 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.