i have to fetch the data based on non primary key field from a pooled or cluster

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?

Question Posted / siva

1 Answers
5421 Views
Wipro, I also Faced
E-Mail Answers

i have to fetch the data based on non primary key field from a pooled or clustered table, but for po..

Answer / 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

More SAP ABAP Interview Questions

what is the T.Code to function module?

11 Answers FutureSoft,

What is the exact use of Reuse_alv_field_catlog_merge.

2 Answers IBM,

1) What is read with binary search? 2) I have initialization write ?a? Top-of-page write ?b? what is the output for this/ 3) If I don?t have start of selection event in report will it execute?it is mandatory or not? 4) What is table maintenance generator? 5) Is it advisable to have secondary index/ 6) How we will imlement BAPI? 7) What is process code in idoc? 8) Where the information msg will display? 9) Where warning msg will display? 10) Where we use watch point?what exactly watch point means? 11) What is a spool? 12) What is program name that contains all print program names and form names other than TNAPR? 13) How we will capture errors in bapi? 14) How to transfer std text from production to quality?

5 Answers CSC,

what is the importance of macros? is it that it is useful only for addition or subtraction operation (arithmetic operations) ? I need more information regards this? I am waiting for the reply

3 Answers

difference between type and like in detail way

10 Answers DSS,

what is the difference between templates and tables.

1 Answers CTS,

What are logical data bases used in hr module? : abap hr

0 Answers

Can i Have Some Realtime Examples on Idocs ?

1 Answers

What data is contained in data dictionary? : abap data dictionary

0 Answers

What are the advantages of logical databases?