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

What is the significance of delivery class? : abap data dictionary

768


What is the function of a data element?

806


What is the difference between a pool table and a transparent table and how they are stored at the database level?

793


How to Modify Layout set for RVORDER01 for printing sales order confirmation. plz mention the detail coding Tahnks, Rahul

3620


What is the function of the correction system?

753


What is the use of table control in bdc is it same in module pool table control? : abap bdc

872


Explain get cursor field?

872


what is sales order confirmation and how can do design it in webdynpro. what is Tcode for the same?

2185


Which commands are used for interactive reports?

865


What are the restrictions on subscreens?

886


What will happen when we use fully buffered in abap?

758


How to combine multiple billing into one RV document ( Step by Step)?

1727


What is dialog module?

789


How will u handle the situation – In a report using function module to generate a IDOC, How will u handle the error IDOC in the same report ?

1871


Describe the difference between macro and subroutine?

835