when u create an index in Data Dictionary..how do we call it
in a program or report..?
Answers were Sorted based on User's Feedback
Answer / amith
Suppose you have created a secondary index for a field
EMPNAM in the table ZDETAILS.
Then you can use the statement
select * from ZDETAILS where EMPNAM = 'XXX'.
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / ravi kr sharma
To use the index created, use the fields which are used for creating the index in the WHERE clause of the SQL statement. The system automatically uses the index if one is found which is based on the field in the WHERE clause.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / gvkreddy
if we want to get the records very fast by using it is
possible by using stmt called READ.....index <idxno> statement
in program or report
Is This Answer Correct ? | 2 Yes | 11 No |
How to combine multiple billing into one RV document ( Step by Step)?
What are secondary indexes. How can we know which index is being used in a select query?
iam having 3 internal table how can i pass data to the 4th internal table
what are the characteristics of a bapi?
what do u mean by occurs 0
how do you transport lsmw data from one system to another?
how many types of data is there ?what is customizing data?
What does an extract statement do in the ABAP program?
Wh bapi u have used in rfc?
what is inline documnetation?
WHAT IS TABLE BUFFERING AND ADVANTAGE?
How to Handel Duplicate entries in LSMW.