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 is the advantage of structures?

584


What are the two statements which are required in an abap program to output an icon using a write statement?

770


if while coding power goes off , how to retrieve the codes?

1626


What is the use of message command in a report? What are the different message types?

553


Can we use flow logic control key words in abap/4 and vice-verse?

566






​​What is the symbol to do “concatenation” operation in​​ nw​​ abap​​ 7.4​​ ?

776


What is an interactive report? What is the obvious difference of such report compared with classical type reports?

563


How can you display frames (horizontal and vertical lines) in lists?

618


What are the events used in abap in the order of execution?

561


THANKS ALL. i CLEARED THE INTERVIEW OF INFOSYS BASED ON THIS QUESTION SET. IT REALLY WORKS. LONG LIVE ALLINTERVIEW.COM

15761


If a table that is to be extended contains a long field, we cannot use append structures why? : abap data dictionary

662


How do you populate data into a multiple line field?

586


what is diff between idocs,bdc,rfc and bapi. give real time answer

17734


Which function module would you use to check the user’s authorization to access files before opening a file?

609


What is table attribute? : abap data dictionary

571