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 / bandivenkateswarlu

Index is used to retrive the fast access the data from the
database by using the indexes. This is the efficient
mechanizam to retrive the data differnt databases.

indexes are two types of given below.

1.primary index.
2. secondary index.

1.primary index.: is used to access the only one record from
the database. That means that should be unique. It is also
called one to one relation ship.
2.secondary index: is used to access the data only more than
one record data base. This is called the secondary index.
The secondary index is used to relation ship is the
one-to-many relationships.

Is This Answer Correct ?    5 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are uses of foreign key?

774


How would you define the exponents for a type ‘f’ field?

816


What is size category?

736


What is view? Explain the different types of view?

948


What is view? Different types of view. Explain?

770






What is the structure of bdcmsgcoll? : abap bdc

980


Difference between open sql and native sql? : abap data dictionary

785


Does the external program run in the same sap luw as the caller, or in a separate one?

844


How many main windows are allowed in sapscript?

764


What is img? : sap abap hr

874


What is the difference between scrolling a table horizontally and vertically?

773


Difference between user exit and badis?

814


What is exception class and test class. How to use it?

1094


What are the personnel administration related infotypes? : abap hr

789


How to read 5th record from Hash Internal Table?

1035