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

Why do we declare a method of a class final? What can be the purpose? Give a scenario.

890


Define abap/4 layer?

752


Difference between .Include and .append?

731


What is the function of the correction system?

563


What is an abap?

544






Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?

1063


hi my name is amit i have passed BE(CSE) with honours(72%) in 2006 yr. i have completed SAP/ABAP training with good exposer. i need a staffing company which can provide me real time exposer in SAP R/3. so plz help me out and send any information regarding on my mail id or tele. no. 9999784331 thanks

1443


Explain what are the different functions used in sap script?

542


Name some system global variables you can use in abap programs?

544


How did you test the form you developed? How did you taken print?

606


Explain the different types of view?

596


What are the various events associated with screen programming?

684


Explain how to write a bdc - how do you go about it?

599


performance tuning concepts

947


What are the attributes of the data in data dictionary? : abap data dictionary

597