Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Secondary index

Former Member

‎06-17-2010 3:40 AM

0 Kudos

Hi Guys,

We are creating a secondary index for a table which is part of a database view. The data from this view is retrieved externally by SAP Java connector. The data will be retrieved using this secondary index key field.

Now the question is, will creating a secondary index for the table which is defined in a view and whose values are retireved externally, really help? my belief is secondary indexes are more helpful when we use them within SAP, that is basically in the select statement in ABAP. Or is it the other way too?

Please suggest ...

Rgds..

1 REPLY 1

former_member657499
Participant

‎06-19-2010 4:20 AM

0 Kudos

When you mount an index then it actually registers that at database level (Oracle, SQL, DB2 etc). Therefore, your external calls should still be able to make use of the index.