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?

Answer Posted / jenny

Indexes are a sorted copy of the table that exist in the
database which helps in faster retrival of data from the
database.
Primary Index : User cannot create a primary index, the
system creates a primary index by default based on the
primary keys of the table.

Secondary Index : The secondary indexes are created by the
user.we can create a maximum of upto 15 secondary indexes
for a table.

Is This Answer Correct ?    19 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

HOW CAN YOU USE A PAGE COUNT IN CALLING A PAGE IN SMARTFORM?

1640


How do you activate a function exit?

572


What is a fall back class?

1020


What is the difference between field-group header and other field groups? : abap modularization

573


What are the other modules integrated with om? : sap abap hr

550






How to convert the Unit for 'Distance' (The value from one Unit to another).

1444


What are the differences between table controls and step loops?

563


What is interactive reporting?

621


What is the difference between a substructure and an append structure?

629


Explain some essential objects in abap dictionary?

710


What is the bitwise operator in the sap abap?

593


What are base tables of an aggregate object? : abap data dictionary

615


What are the payroll related Infotypes

1823


Reports: Event functionality.

893


What are pooled tables? : abap data dictionary

669