Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5295 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
Can you define a field without a data element? : abap data dictionary
How many types of data classes are there in sap?
What are subroutines? : abap modularization
What are the function modules used in a sap script driver program?
What are the events we use in dialog programming and explain them?
what is friend class
How would you suppress the display of a parameter on the selection screen?
Explain how to create any functions? How to go about it?
Does sap handle multiple currencies?
Is the basic list deleted when the new list is created?
What are the types of subroutines?
Explain the components of selection table?
What is pakey structure, pshd1 structure and what type of fields it contains? : abap hr
What is generic buffering?
Is it possible to pass data to and from include programs explicitly? : abap modularization
