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

How to create Secondary Index?

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

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

      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

  • Posted on Apr 06, 2006 at 06:58 AM
    Add comment
    10|10000 characters needed characters exceeded