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 |
Check table value table
Where do you code the hide statement?
how to upload open purchase order through BDC
Workbench request are client dependent or client independent
I have developed a program where i have used Ranges and the program is running fine in DEV and Quality server but as soon as it goes to Prod server it shows some errors.What can be done in this case??
Can we include customizing include or an append structure with pooled or cluster tables?
In SAP Query with out know user that query can we execute?
how do you put dynamic page breaks in script.
why SAP script is clint dependent and smartform is clint indepedent ?
the problem is that , while i am undergoing with my practice session, i am creating too many new programs.they are occupying much space in my hard-disk. how to delete un-necessary programs completely from my data- base........... plz help me with this .....
What is the use of table maintenance allowed?
Explain how data is stored in cluster table?