Hi,
If there are more than 15LAC records in the "cdetail" and "clm" table, Timeout exception occurs. Could anyone please help me in increasing the performance of this query: (Is there any way without using index)
[code=sql]
SELECT clm.ft, cdetail.clmid, cdetail.cline,
cdetail.servcod e, cdetail.revcode , clm.bccode,
clm.fycode FROM cdetail
INNER JOIN clm ON (clm.clmid = cdetail.clmid)
INNER JOIN bplan ON (cdetail.pid = bplan.pid)
INNER JOIN pgm on pgm.pgmid=bplan .pgmid
WHERE
bplan.pgmid in ('DMXHPQ1596', 'DMXHPQ1600', 'DMXHPQ1601', 'DMXHPQ1602')
AND
pgm.cgp > '' AND
clm.sts IN ('AJ', 'PD', 'PY', 'RV', 'WP', 'DN', 'VD')[/code]
If there are more than 15LAC records in the "cdetail" and "clm" table, Timeout exception occurs. Could anyone please help me in increasing the performance of this query: (Is there any way without using index)
[code=sql]
SELECT clm.ft, cdetail.clmid, cdetail.cline,
cdetail.servcod e, cdetail.revcode , clm.bccode,
clm.fycode FROM cdetail
INNER JOIN clm ON (clm.clmid = cdetail.clmid)
INNER JOIN bplan ON (cdetail.pid = bplan.pid)
INNER JOIN pgm on pgm.pgmid=bplan .pgmid
WHERE
bplan.pgmid in ('DMXHPQ1596', 'DMXHPQ1600', 'DMXHPQ1601', 'DMXHPQ1602')
AND
pgm.cgp > '' AND
clm.sts IN ('AJ', 'PD', 'PY', 'RV', 'WP', 'DN', 'VD')[/code]
Comment