Regarding Performance Tuning
In one of my Program, i am using SELECT query with BSEG table, which is leading to performance issue while generating the report.
I have optimised the select query in all possible ways to reduce the execution time.
Still the report is taking almost 1 minute time to execute this select statment.
if not it_wbs1 is initial. select bukrs belnr gjahr dmbtr hkont projk from BSEG into corresponding fields of table it_bseg for all entries in it_wbs1 where bukrs = c_bukrs "1000 and gjahr = V_YEAR2 and shkzg = c_shkzg "H and projk = it_wbs1-wbs_in and hkont between c_hkont1 and c_hkont2. "'0001101001' and '0001999999'. endif.
I heard that instead of using BSEG directly, we need to create a database view of BSEG with limited fields (Which are necessary for this select statement) and the database view should be queried instead of BSEG.
Is it worthful to reduce the execution time?
Or Any other idea to fine tune the Program in this regard?
Moderator message - Moved to the correct forum
Edited by: Rob Burbank on May 21, 2009 9:37 AM