Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
but how to use primary index and secondary indexes in select statment .shall we use both at same time in select staament .please explaine me with examples.
primary index will be used by default in all the Select statments, if you do not specify in INDEX with the select statment, then the primary index will taken by SAP automatically.
If the underlying database is ORACLE, then you can specify the secondary index to be used by the following statement:
but how to use primary index and secondary indexes in select statment .shall we use both at same time in select staament .please explaine me with examples.
You cannot force the use of INDEX, its upto the Database Optimizer in the Workprocess to decide weather to use the INDEX or NOT.
BUT INDEX will be used when your SELECT query's WHERE CLAUSE has as many fields of INDEX as possible. Also you need to put the fields in the SAME ORDER as they appear in the INDEX.
So if your index is on FLD1 FLD2 and FLD3
then in your query use SELECT * FROM TAB WHERE FLD1 = and FLD2 = and FLD 3.
primary index will be used by default in all the Select statments, if you do not specify in INDEX with the select statment, then the primary index will taken by SAP automatically.
If the underlying database is ORACLE, then you can specify the secondary index to be used by the following statement:
We can use both secondary index and primary index in a single select statement. First we need to use secondary index in where condition then we can use primary index after that non primary keys. if secondary index is not there we will use primary index directly.
Bluesky
