Hi all,
Below is the statement that i have used for fetching the data from CATSPS,when iam doing runtime analysis the data fetching from CATSPS is taking 75% of time .
Is there any possibility to reduce the runtime for fetching data from catsps.
SELECT COUNTER LSTAR CATSHOURS MEINH STOKZ RAUFPL RAPLZL WORKDATE
INTO TABLE T_CAT FROM CATSPS
FOR ALL ENTRIES IN T_ACTIVITY
WHERE RAUFPL = T_ACTIVITY-AUFPL
AND RAPLZL = T_ACTIVITY-APLZL
AND LSTAR = T_ACTIVITY-LARNT
AND WORKDATE BETWEEN W_BEGDAT AND W_ENDDAT.
In general what are the things that should be considered performancewise while writing select statements.
Thanks & regards,
Kiran...