zindex creation on standard sap table

[Former Member]

hi,

i have created z index on bsis table.

after successfully creation of index there is a message:

"Index does not exist in database system MSSQL"

what is the meaning of this message.

raj

[former_member404244]

Hi Raj,

u have to do database utility(SE14),activate and adjust ur table in se14,so that it reflects in the database level also..Try doing this ...

Regards,

Nagaraj

[Former Member]

thanks nagraj - full point

i use create button for my exist z index.

now the message is changed :

Index BSIS~Z01 exists in database system MSSQL

as per my knowledge performance can be better if index is exists in database.

regards

raj

[Former Member]

Not necessarily - what's the index on?

Rob