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
- 5358 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 table buffer? Which type of tables used this buffer?
How do you set up background jobs in sap?
How do you set up background jobs in sap? What are the steps? What are the event driven batch jobs?
How do you send files to the legacy systems from sap and vice versa? How does one know that the legacy files have come on to the sap server you are working on? : abap bdc
What’s value table?
What is meant by authorization? Did you ever work on it? : sap abap hr
What is roll area?
What is the difference between the function module and a normal abap/4 subroutine? : abap modularization
Explain what are the different functions used in sap script?
What is your current client number?
What is difference between dependent and independent data?
Which transaction code can I use to analyze the performance of abap program?
How to create any functions?
How do you find the information on the current screen? : abap bdc
What is personnel sub are
