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 do you call third selection screen ?

1633


What is the diffreence between bdc_close_group and bdc_close_dataset? : abap bdc

605


Explain the different types of mode (run code) in call transaction method?

563


What is the difference of update types in call transaction method ? : abap bdc

625


What is lock object ? : abap data dictionary

597






How to creat transactions? : abap data dictionary

638


Difference between stand alone CRM and back-end CRM

3814


From Excel to ABAP - Is batch mode possible ?

576


What are the parameters used in each function?

593


Explain the difference between tables and structures?

477


What are the advantages of logical databases : abap hr

592


On ABAP, Did you set up a workflow? Are you familiar with all steps for setting up a workflow?

587


What are the different abap/4 editors?

557


How to use messages in lists?

598


What is ps structure? : abap hr

793