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

In a loop of an internal table, what is the use of at first & at last statements?

1469


What are the different control break statements available inside a loop?

573


Explain the systems fields used for interactive lists and lists?

522


Explain the use of insert and append statement in sap abap?

580


Explain the advantages of logical databases?

575






What is macro? : abap hr

631


What is the tcode to create indexes?

585


How to write a bdc – how do you go about it?

653


What are the main uses of the primary key?

719


Did you use buffering?

588


did u done enhancement framework?how u implemented?

5033


Difference between function group and function module?

635


What is ole?

677


What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?

735


What is the maximum number of structures that can be included in a table or structure : abap data dictionary

793