i have to fetch the data based on non primary key field from a pooled or clustered table, but for pooled and clustered tables we can't create secondary index then to achieve the performance what to do?
Answer / marek
I assume this question is not about SAP HANA, but the old fashion data bases.
You should avoid selection from cluster data base table. The better way to do this is to use base tables. For example if you want to select data from BSEG table you should use "lower level" tables like BSAK BSIK BSAD BSAK etc.
Also to achieve this you can use standard function module or some kind of BAPI designed for this purpose.
As always you should remember to use optimized WHERE part of the query and WHOLE key in exact the same order like it is in data base (of course this optimization practices can only be applied to one type of DB, Orcale and MS have different ways to optimize the SELECT statement). Additionally you should one import fields you need to, trying to avoid the '*' usage as much as possible. Using FOR ALL ENTRIES and INTO CORRESPONDING FIELDS is not efficient as well.
Is This Answer Correct ? | 0 Yes | 0 No |
How do you write UTP?(unit test plan)
difference between cluster and pooled tables
4.why dont use start form in script?
How can u call a Report from a module pool program?
From excel to abap - is batch mode possible ? : abap bdc
What are the steps carried the ALE?
What are the FM you used in Session method?
What is the difference between occurs 1 and occurs 2
How to transfer the objects? Have to transferred any objects?
hi i have one requirement on smart forms.i have to print customer details and order details(Based on customer number) in two windows.I want to write total code in report it self.can any one please help me? Thanks in an advance Vijay
How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?
how COLLECT and APPAEND works ,,