Skip to Content
0
Former Member
Oct 15, 2005 at 06:55 AM

Performance issue for CATSPS

37 Views

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...