on 11-02-2007 9:05 PM
Hello Friends. Logic Start Routines are causing Performance issues of 1 hour data load, IS IT recommended to do indexing on DSO Table. If YES HOW. please tell me step by step. I want to Have 0PROFIT_CTR and 0COMP_CODE , ZEMPCODE Fetch in the start routing code from one table and then map with other dso table 0PROFIT_CTR and 0COMP_CODE and Fiscper. data of current quater. so how to index the dso So that performance can be improved
Please help me here instead of links will be appreciated
Thanks
Soniya
Hi,
It would be easier to help you if you post your start routine code...
But yes, adding apropriate index for DSO will speed up data access but it also can slow down data loading to this DSO...
In order to add new index to DSO go to RSA1, then find your DSO in InfoProviders and go to edit mode. There is special node in DSO definition called index. You can create new index from context menu and then drag fields on index node to add them...
Krzys
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.