Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from emohtadi on Apr 23 at 2:23 AM Hi Friends, Thanks To All
My query performance was better by using index and sequence of primary key in where clause.
emohtadi
| | | ---------------Original Message---------------
From: emohtadi
Sent: Tuesday, April 14, 2015 2:38 AM
Subject: Performance Issue FAGLFLEXA
Hi Masters,
How to select the data efficiently for the table FAGLFLEXA?
This is my query:
Executed time is about 10 minutes.
SELECT-OPTIONS:
s_hkont for faglflexa-racct,
s_prctr for faglflexa-prctr,
s_date for bkpf-budat.
data begin of pre_h OCCURS 0.
data racct type faglflexa-racct.
data prctr type faglflexa-prctr.
data hsl type faglflexa-hsl.
data rwcur type faglflexa-rwcur.
data end of pre_h.
select racct prctr sum( hsl ) rwcur into table pre_h
from faglflexa
where racct in s_hkont
and prctr in s_prctr
and budat < s_date-low
and drcrk = 'H'
and rldnr = '0L'
group by racct prctr rwcur.
Best Regard. |
| Reply to this email to post your response. __.____._ |  | emohtadi
Programmer/Developer - Software | |   _.____.__ |
