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

1.How to pass the variables to form? 2. How did you test the form you developed? 3.what are the outpout types and tcodes? 4.what mean by performance analysis?

1 Answers  

15) What is a Normal,Constant and Variable Window?

2 Answers  

how do you put dynamic page breaks in script.

1 Answers  

What are the main uses of the primary key?

0 Answers  

can anyone give me notes on bdc direct input method

1 Answers  

For particular transaction you want to upload the data using any of bdc method...if the transaction contains any of pop window functionaliy and having radio button in the window..Any one of the radio button must be selected then only the next data can be inserted how will you handle this scenario in your program

2 Answers   TATA,

What is screen flow logic? What are the sections in it? Explain PAI and PBO.

1 Answers  

What is BSP Application & Extension?

1 Answers  

Normally how many and what files get created when a transaction program is written?

0 Answers  

Hi Experts, we have coded in smartforms also but why we r going to driver program for smartforms..

3 Answers   IBM,

How can we determine a vendor is Bloc/Unblock from the table LFA1?

0 Answers  

What is the difference between native sql & open sql? : abap data dictionary

0 Answers