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

Explain Singleton class

1052


In an abap/4 program how do you access data that exists on a presentation server vs on an application server?

928


In ALV reporting when u execute your report which event gets triggered.

1993


What is a size category? : abap data dictionary

858


Can matchcode object contain ids with different update types? : abap data dictionary

871


Where can you find error log for call transaction? : abap bdc

997


Explain what are the events used in interactive reports?

717


In sap script how to print bar code in vertical manner

3715


Which one is better joins or views and why?

850


10) How to get Item Header in Sales Order?

1766


Explain how do you move on to the next screen in interactive reporting?

787


Explain the disadvantages of abap query tool?

819


How to Raise a Particular Ticket in Realtime ?

1972


What are the attributes of a field that can be activated or deactivated during runtime?

783


In which table the material master data is stored?

780