What is an index ? Types of index and there uses ?
Answers were Sorted based on User's Feedback
Answer / suman
2 types of indexes
1. Basic index - default it will exist for tables.
2. Secondary index - we need to create on requirement.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / aditya sharma
There are two types of indexes:
1.Primary Index
2.Secondary Index.
While creating a table or in an existing standard table the
key fields are the default primary indexes.
If we require to fetch records from non key fields we need
to provide Secondary Indexes.i.e., we need to explicitly
make non key fields as indexes.
This can be done by clicking on Index and adding the fields
for secondary index.
For Some major standard table SAP has provided secondary
Indexes like
Eg: BSEG table. As BSEG is a cluster table data retreival
using non key fields like Customer/vendor/GL account data
makes the response slower.So SAP has provided standard indexes.
Secondary index tables:
For Customer BSID and BSAD.
For Vendor BSIK and BSAK
For Material BSIM
For GL AccountBSIS
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / yarru sreenivasa rao
grouping of fields
index contain idexfields and pointer to data record in that
table
unique index
nonunique index
speed up the data retrieval due index fields r sorted
Is This Answer Correct ? | 4 Yes | 0 No |
Why don’t use LSMW method instead of BDC methods, if the data is master data?
If i have 6 fields in our ztables,But when i would like to display the contents,then only 4 fields would be come up,HOW IT WILL Handle?
What are the various events associated with screen programming?
Whom do you report when you find difficulty in Tech. designing?
Plz can any one tell me about the detailed information of issues raised by the enduser, as an abap developer how we need to pick up that issues and what are the steps involved in the process(support project ), and tell me about the tickets. who is the person that is going to generate the tickets( send the detailed information regarding the support project and as a abap developer, what is its roles and responsibilites from beginning to the end of support project .
What is the use of update Function Module ? Where it is used and purpose ?
What is a multiple line field?
Give few names of cluster tables in sap ?
25) Can we create more than one main window in smartforms?
if data is inserted only using bdc open and bdc insert and not bdc close session funx module wat will happend? will data b inserted?
Did you use buffering?
What is difference between inner join and outer join?