Answer / sudhakar1207

SECONDARY INDEXES ARE USED FOR FAST RETRIEVAL OF DAT FROM THE DB TABLES.

WE CAN CREATE MAXIMUM OF 15 SECONDARY INDEXES.

Answer / paru

If primary index is not enought to speed up the data
retrieval, We can create secondary index.

Maximum Limit: 15
Advisable : 6 or 7.

Answer / sateesh

primary keys of a table are defined as primary index.
if it is not sufficient for improve the performance.
we will create secondary indexes.maximum 15 secondary indexes
possible

Answer / shankar

in sap abap two types of indexes are they supported
1) one is primary index it is automatically created when ever
user create table it contrains combination of primary key fields
2)secondary index can be created user it is combination
of some primary key fields and non primary key fields
there is no limit creation of secondary indexes
try it and make sure maximun less no of indexes are suggests
if more indexs user can not understand which index is used

Answer / sagi.nagamani

to increase the performance in getting data from data base
table i.e. to speed up the process.we can create
secondary indexes maximum 9.

Answer / g.shankar

sorry for the above ans 2ndry index is used to enhance the
performance of a select statement for a non-primary key...

Answer / g.shankar

guys the question is about 2ndry index not about only index..
2ndry index is used to increase the performance for where
condition..and we can create a maximum of 16 2nry indexes..

How do you populate data into a multiple line field?

0 Answers  

what are conversion routines

3 Answers  

MY DOMAIN IS SAP-ABAP COMPARE TO WEBDYNPRO AND CRM-TECHNICAL WHICH IS BEST?

0 Answers  

. what is badi? 10. what is the difference between user-exit & BADIs? 12. how do you get functional specs when you are assigned some object? (specs through email..??) 13. How do you write technical specs?

4 Answers  

In the performance standards we have SE30 for Run time analysis where it will show the system count,abap count,data base count if it is more than means then what we will do let us take my abap count will be some 30% and data base will be 60% and system count 50% now what i want to do

2 Answers   HCL,

HOW MANY IMPLEMENTATIONWE CAN CREATE IN BADI? WHAT IS THE USE OF REUSABLE IN BADI? HOW MANY IMPLEMENTATION IS ACTIVE IN PRODUCTION SYSTEM AT A TIME?

2 Answers   Siemens,

What are aggregated objects

0 Answers  

What do you mean by correction and Transportation system?

1 Answers  

How would you suppress the display of a parameter on the selection screen?

0 Answers  

Can we reuse a userexit?

0 Answers   HCL,

What are function modules in scripts?

2 Answers  

Did you create any joins?

0 Answers