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
- 5428 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 a transport?
What are matchcodes?
can any one answer these questions 1)How do you convert non-character field to character field? 2)How do you work with semi colon separated files? 3)why cant we use normal function module for data transfer? 4)what is the structure of CTU-PARAMS? 5)can we use transfer dataset to transfer data in internal table?
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul
What is the use of the raising exception? : abap modularization
What statement will be found in an sap application program that implements a function module exit?
What are the two levels in defining a match code ?
What are the data types of the abap/4 layer? : abap data dictionary
5) How to rereive text elements in SF and script?
Lock objects and what are parameters of ENQUEUE FM?
What are the differences between transparent tables, pooled tables & cluster tables? : abap data dictionary
What are control tables? : abap data dictionary
Why is pretty printer user in abap?
Explain the call transaction method? : abap bdc
Explain difference between primary key and unique key?
