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
- 5237 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
How to upload data using catt ? : abap hr
How can we upload a text file having delimiters in to legacy system?
What is the difference between skip and new-line?
What are client dependent objects in abap/sap?
How does the interection between the dynpro and the abap/4 modules takes place?
While doing bdc exp va01 transaction sometime in the item level data shows only 4 items and other times it will show 6 line items, how will you maintain this kind of screen resolutions scenerio? : abap bdc
What are the aggregate objects in the data dictionary? : abap data dictionary
Folder types in smatforms? 2)What is Command line?
What are field symbols?
Different types of luws. What are they?
Rp_provide_from_last contains how many parameters ? : abap hr
What are different types of parameters?
Suppose there is check box along with the rows. The requirement is, select the require check boxes and press a used defined button to save all these checked row data to another table. How can you do it?
What are the different functions used in sap script?
What is the master data necessary before you can start posting in MM?
