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 are base tables of an aggregate object? : abap data dictionary

0 Answers  

What is an index? By default system will create the primary index or User can create,if user How? And also Secondary indexes by User or by defaultly system?

2 Answers   TCS,

what are the main technical differences between oracle and sap? it would be more helpful to me if get this answer...

0 Answers  

have you used performance tunig?what major steps will you use for those

1 Answers   Deloitte,

How to create hashed tables?and its purpose

2 Answers   Accenture,

When a function module is activated syntax checking is performed automatically. State yes or no. : abap modularization

0 Answers  

What are the steps to execute session method?

0 Answers  

Why don’t use LSMW method instead of BDC methods, if the data is master data?

2 Answers  

how to handle events in classical reports?

2 Answers  

A field containing quantity amounts (data type quan) must be assigned to a referencetable and a reference field. Explain?

0 Answers  

how to restict the data display in smart form like if i want to display directly in secondary window.

1 Answers  

which method u r perfer to upload flat file data into sap system

3 Answers   Deloitte,