where can u use secondary index in program please tell me?
is there any tool to test in development client?is there any
performance tool is thre pleaseeee tell me?
Answers were Sorted based on User's Feedback
Answer / sachin
When the selection criteria of select does not use primary
keys. Also the performance of the select for the fields of
criteria is poor then we can create secondary index through se11 on that table . use code inspector SCI tcode or st05
as performance tool for this.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kartik
When the selection criteria of select does not use primary
keys. Also the performance of the select for the fields of
criteria is poor. In this case it is good idea to use
secondary index.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sudheer
i ur tables no primarykeys are not their then u have to use secondary indexes.
bcoz u dont have any primarykey u dont search the records properly.
but inthis case secondary indexes are chosen.
in secondary indexes search the records by using non primary keys in a table.
i performance wise primary key is best when compared to secondary index
Is This Answer Correct ? | 1 Yes | 1 No |
What are the different types of data dictionary objects? : abap data dictionary
How to Read long Text using Scripts
difference between cluster and pooled tables
1)how can you write select statment in scripts(se71) with out touching the driver program
what is code to upload cost centers through call trans. and procedure
Can we make use of flow logic control key words in abap/4 and vice-versa?
What are indexes? : abap hr
Batch Monitor -- Transaction Code?
how to replace the Old BDC transactions with the new enjoy SAP transactions
How many types of views are there? : abap data dictionary
If u use US Database server? How can access the client?
How many records a Read statement will retrieve?