Indexing on R/3 Tables
I am loading data from 2lis_o1_s261(Delivery) from SAP 3.1i R/3. Well when I send a data request from BW, the querying of the S261 Table is taking about 2 hrs for 150,000 records on an average. Is this a good performance?
(Compared to what you all seen before?)
Well FYI. it is just the query run time in R/3 but my upload job on BW runs fast(15 mins max).
Also this table S261 on R/3 is not indexed. So do you experts have any comments on this.
Surendra Kumar Reddy Koduru replied
Performance wise it is not good, because it is taking long time. Is there any exits in that datasource?. And also it is depends on any routiens and formulals in BW trasfer rules and Update rules.See any short dumps in ST22 and also see the job log in SM37.If there is any other programs are working on that tables at that time also it will take time.