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
- 5415 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 are the different types of parameters?
How do you find the information on the current screen? : abap bdc
How to get that a secondary index is attached to a select query?
What are the advantages and disadvantages of ABAP query tool?
SAP Script for Billing in which Billing document number was displayed as header, Bill Type, Bill Category, Bill Item, Cost, Base Unit of Measurement and Material number were categorically displayed for each billing document number. plz mention the detail coding Tahnks, Rahul
Does sap handle multiple currencies?
What are the types of records that are transferred to sap r/3 and used by interfaces? : abap bdc
What is pretty printer?
There is a delivery that is being created through the ABAP code and in the middle it says delivery created but someone is modifying , how would you rectify this issue
What are the functions of lock objects?
In tm, if a group of employees gets 10 days of annual leave, what will be the time evaluation status? : sap abap hr
Advantages and disadvantages of different types of bdc's?
On ABAP, Did you set up a workflow? Are you familiar with all steps for setting up a workflow?
What is the purpose of sum statement?
What are the function modules used in f4 help?
