Skip to Content
author's profile photo Former Member
Former Member

How to create Secondary Index?

Posted on Apr 06, 2006 at 06:28 AM 160 Views

Hello All

Can anyone let me know how to create secondary indexes?

I hope Primary Indexes are being created automatically?V can'nt able to create this.

regards

balji

BW Content and Extractors Chemicals
Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 06, 2006 at 07:02 AM

    Hi Balaji,

    Yes difinitely ou can create secondary index on ODS. As you know ODS is nothing but a transparent table. The index in database table is applicable to ODS. There are 2 kinds of indeces. Priomary and secondary. Primary index is created by system based on the primary key of the table. In case of ODS depending on the key fields( infoobjects). In case you need to create secondary index you must go to ODS maintainence and choose Index folder and right click on it to Create.

    Please note index is created to enhance the performance but wrongly defined index has adverse effect on it i.e. decreases the performance. It may enhance perfomance for you but will reduce the performance for other user so need to be very careful. In case you need further information on this please let me know.

    cheers,

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 06, 2006 at 06:36 AM

    hi Balaji,

    yes, primary index are created by system.

    secondary index, for ods you can create with ods maintenance, right click 'indexed' and add infoobject(s). activate ods again.

    or use se11, put in table name, and click 'index' and 'new' (blank page icon).

    hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Aug 02, 2006 at 03:14 AM

      Thanks Anil

      Would you pl elaborate for pt.2 and 4.?

      Also For Cube , we need to create index or system will automatic will create an Index?

      Thanks

      KK

  • author's profile photo Surendra Kumar Reddy Koduru
    Surendra Kumar Reddy Koduru
    Posted on Apr 06, 2006 at 06:58 AM

    Hi

    http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21eab8446011d189700000e8322d00/frameset.htm

    it may help you

    Thanks

    REddy

    Add comment
    10|10000 characters needed characters exceeded