how many type of index are there

Answer Posted / sudhakar1207

Indexes are used for Fast access of records from database
tables.

There are two types of indexes.

1)Primary Index: these are created automatically while table
is activating. It comprised of all the primary key fields only.
2)Secondary Index: these are created manually on rare
situations. These contains combination of primary key fields
and Non-primary key fields or Only Non-primary key fields.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the difference between call screen and leave screen?

607


What is the relationship existing between the various data elements? : abap data dictionary

595


Where do you code the hide statement?

575


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 ?

1678


How to upload data using catt ? : abap hr

620






10) How to get Item Header in Sales Order?

1561


The commands through which an abap/4 module can “branch to “ or “call” the next screen are?

637


I have 3 transactions,where the output of one transaction is input of another and output of 2nd transaction is input of 3rd transaction.i have one flat file with all data for the 3 transaction.if the 3rd transaction failed can we rollback the remaining 2 transactions or not.Is this possible in BDC,How/

1817


What is the function of a domain?

649


Value table VS check Table.

964


Difference between user exit and badis?

614


What are the two ways for restricting the value range for a domain? : sap abap data dictionary

728


Define external layer?

639


Difference between function group and function module?

650


What are the different types of the sap abap data dictionary objects?

550