Table Secondary Index Option "No database index"

[Former Member]

Questions here are:

1. does the "No database index" option have any benefit to performance?

2. if not a DB index, then is there an index at all?

I am looking for an experienced response, not just to have the documentaion sent back to me.

I am on MSSQL.

[clas_hortien]

Hello,

the message means, that the index is defined in the SAP data dictionary, but does not exists on the database. The missing index might be a performance problem, as it was designed to help certain statements too run faster. But it also might be possible, that it is only an optional index, which might not be needed in every system / for every datasets.

You can check for all missing indexes in

DBACockpit => Diagnostics => Missing Tables and Indexes

To answer your questions:

1.) It might be, if in doubt then create the index

2.) No, if you see this message, then the index does not exists, but the table might have other indexes.

Best regards

Clas

[Former Member]

ty