Missing Indexes

[mohsin_m3]

Hi,

DB02OLD  lots of primary and secondary indexes are present in ECC system .

How to create missing indexes with compress option .

Primary indexes                

    BSAS-0

    CE41000_ACCT-0

    GLPCA-0

    STXH-0

    TOA01-0

    VARIT-0

Secondary indexes               

    BSAS-Z06

    BSAS-Z04

    BSAS-Z03

    BSAS-Z02

    BSAS-Z01

    BSAS-1

    COSP-2

    GLPCA-2

    GLPCA-3

    GLPCA-7

    GLPCA-Z02

    GLPCA-Z03

    JEST-I

    SRRELROLES-002

    SRRELROLES-003

    STXH-Z01

    STXH-REF

    SWWLOGHIST-1

Please help me with Brttol option or sql quary

Thanks and Regards

Mohsin

[Former Member]

Hi,

You can go to SE14 and try to create index Please see the below link

http://help.sap.com/saphelp_nw04/helpdata/en/cc/7c58b369022e46b629bdd93d705c8c/content.htm

You can refer the below note for additional information.

Note 334224 - Important notes for creating indexes

Thanks and Regards,

Vimal

[Reagan]

Hello

Call Tx SE14 to do that.

Cheers

RB

[former_member206552]

hi mohsin

please review the following

http://help.sap.com/saphelp_nw04/helpdata/de/75/95536a63b44b4a9e7f278c7d9c2b67/content.htm

http://scn.sap.com/thread/3212577

best regards

marius

[Reagan]

Hello

please review the following
http://help.sap.com/saphelp_nw04/helpdata/de/75/95536a63b44b4a9e7f278c7d9c2b67/content.htm
http://scn.sap.com/thread/3212577

The problem here is with the missing indexes and NOT how to rebuild the indexes.

The SCN discussion is about Compression.

Cheers

RB