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..

What is the difference between synchronous and asynchronous update?

0 Answers  

What happens if we use leave to list-processing without using suppress-dialog?

0 Answers  

How can we create callable modules of program code within one abap/4 program?

0 Answers  

you have own g table & kna1 table how to attach the search help for g table as well as kna table?if u press f4 on selection u should display only primary key field of kna1 as well as g table fields

2 Answers   IBM,

SUPPOSE WE ARE RUNNING A BDC PROGRAM IN BACK GROUND AND AT THE END WE FOUND THAT SOME RECORDS ARE NOT UPDATED?WHAT IS THE SOLUTIONS

2 Answers   JS SoftMerchants,

What is binary search? where it is used?

2 Answers  

Update function modules are classified as either v1 or v2. Which type of update is performed first and in what mode (asynchronously, synchronously or locally) can each type be processed in?

0 Answers  

What will happen if we write “WRITE” statement in the TOP_OF_PAGE? Can we write?

2 Answers   Accenture,

What is the transaction code to display the payroll results ? : abap hr

0 Answers  

What is the program flow of BADI(step by step)?

2 Answers   HP,

how do u know what is the exact user-exit for that particular enhancement.

1 Answers   IBM,

What is the use of AT Selection Screen output when we have At selection screen?Can u explain?

6 Answers   Genpact, Wipro,