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 is the difference between data: begin of ty_emp, eno type i, ename type string, dno type i, end of ty_emp. and types: begin of ty_emp, eno type i, ename type string, dno type i, end of ty_emp.

7 Answers   Ameks, TCS,

what is the default event that is triggers in report?

9 Answers   TCS, Unilogic Software, Unilogic Technologies,

how to caluclate sub total of some specific fields ? Ex 1 a 2000 2 a 324 3 b 3245 i want total of all a's ,,, please dont use collect

3 Answers  

How do we create the Field exits?

1 Answers   IBM,

What are the functions of lock objects?

0 Answers  

What is SY-LOOPC and SY-STEPL?

1 Answers  

what is meant by serialization ?

1 Answers  

i have a doubt ,what is the difference between the workarea and headerline . plz tell me .

3 Answers  

If BDC is developed in Development system with no data , where do we do the recording?

1 Answers   HCL,

What is updated Function Module.

3 Answers   IBM, Intelligroup,

LDB is a program or table?

2 Answers   IBM,

What is the difference between Collect statement and Append Statement?

2 Answers   Accenture, Deloitte, Maventic, TCS,