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?
- 1 Answers
- 4880 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the function of a domain? : abap data dictionary
Can i have some Realtime Scenarios on Reports.
What are the sequences of event block?
What is the differences between structure and table in the data dictionary in abap?
What are the system fields? Explain?
What are the events we use in dialog programming and explain them?
Why grouping of fields is required? What is the max no of modification groups for each field?
What are the basic object types? : sap abap hr
Explain the differences between sap memory and abap memory?
What are the dis-advantages of logical databases? : abap hr
What is the difference between skip and reserve?
Under Data Transfer Portion of ABAP, what do you mean by DX Project
What is the difference of update types in call transaction method ? : abap bdc
On which event we can validate the input fields in module programs?
What is the syntex used to call a screen as dialog box (pop up)?
