Answer / malathy

Shankar,
Only primary indexes are created by Default.
secondary indexes are created by the user, it can be
created in SE11.

Answer / balaji

index is used to speed up the selectin of data from tables

secondary index is created in addition to the primary index
of table

Answer / lokesh

By using Index you can search a table for data records
which will satisfy certain search criteria .Using index
will speed up the search .An index can be considered a copy
of the DB table that has been reduced to certain fields.
This copy is always in sorted form. Sorting provides faster
access of the data records of the table.

There are 2 types :

1) Primary index
2) Secondary index

Answer / pooja

How to create secondary index? Explain step wise procedure.

Answer / g.shankar

for fast retrieval of data from database we need index..
2 types of index r der-
1-primary index
2-secondary index
secondary index is created by default..

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

0 Answers  

What is a fall back class?

0 Answers   Infosys,

In se11 -->Tech. settings --> Data class. If I save table as Mater data OR Transaction data, what effect will it has for 'Storage' in Database after activation. or In Database how it will store in both the cases.

0 Answers   Patni,

How do you number pages in Sapscript layout outputs?

1 Answers  

What is static attribute

0 Answers   Infosys,

what is table maintainence?

5 Answers   Cap Gemini,

explain the scenario of ALE/IDOC

1 Answers  

Difference between sy-tabix and sy-index?

0 Answers  

how to add a field to existing TMG with out deleting that TMG. tmg over riding techinique.

1 Answers   Cap Gemini, L&T,

Explain the Inportance of pa30? : abap hr

0 Answers  

What are clustered tables?

0 Answers  

What is Field group?

0 Answers