what is index? I need exact defination? how will create a
secondary index?
Answers were Sorted based on User's Feedback
Answer / malathy
Shankar,
Only primary indexes are created by Default.
secondary indexes are created by the user, it can be
created in SE11.
Is This Answer Correct ? | 6 Yes | 0 No |
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
Is This Answer Correct ? | 5 Yes | 1 No |
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
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / pooja
How to create secondary index? Explain step wise procedure.
Is This Answer Correct ? | 0 Yes | 0 No |
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..
Is This Answer Correct ? | 4 Yes | 8 No |
I am uploading 100 records out of which say 59th record has error so what will happen if I am using synchronous or asynchronous method of bdc? Can we update the database using local update mode how? : abap bdc
What is Macro
What are the function of the transport system and workbench organiser? : abap data dictionary
Overall how do you write transaction programs in SAP?
Is there any BAPI to retrieve list of customers and their sales areas i.e., Cust No, Distr Channel and Division for all the customers.
When i create a Table Maintenance Generator ,which is the event that will Trigger ?
What is INDEX Concept. What is Primary Index and Secondary Index and Difference between Primary & Secondary Index
When a program is created and need to be transported to prodn does selection texts always go with it? If not how do you make sure? Can you change the cts entries? How do you do it?
What is the meaning of table buffer? This buffer is used by which type oftable?
Do you use select statement in loop end loop, how will be the performance? To improve the performance?
in a loop of an internal table, what is the use of at first & at last statements?
Explain difference between primary key and unique key?