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 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 lock objects? : sap abap data dictionary
Mention some important events in abap programming.
What is use of transparent table in abap? How it is different from pool tables?
How do you populate data into a multiple line field? : abap bdc
foreign key enforcement?
How to create report in SD open sales order which covers all Organization, delivery status, shipping details and partner function details. plz mention the detail coding Tahnks, Rahul
What are the user interfaces of interactive lists?
how to read the standard field value in your custom program.
Explain the differences between se01, se09 and se10?
ABAP : Classical reports events name
Lock objects and what are parameters of ENQUEUE FM?
What is the difference between commit-work and rollback-work tasks?
What are the events we use in dialog programming and explain them?
What are two different ways to add fields to sap tables?
How to upload data using catt ? : abap hr