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

‎2006 Jun 06 7:39 AM

0 Kudos
83

Hi All

I need to create a Secondary Index for one of my Z Tables. I need to know which option to be selected while creation

a) Index on all Database System

b) For selected database system

C) No Database Index.

As far as the secondary indexes of the Standard SAP Tables are concerned, some of the indexes are created with Option A) and some of them with Option C.

How to go about this selection and which one will be more effective, Pls clarify.

Rgds

B.S.Krishnan

1 REPLY 1

Peter_Inotai
Active Contributor

‎2006 Jun 06 8:19 AM

0 Kudos
47

I use noramally option a), when I create index. b) can be used if there is an OSS note explaining, that some index has negative effect on some database and could improve performance on some other. For example in ABAP code there is a database specific hint used.

c) is used by SAP, when they planned index in the eraly phase, but didn't used it in the end. It might make sense to activate it, if there is an OSS note for it.

Since it's a Z table, I'd suggest to use option a).

Peter