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 a comment
10|10000 characters needed characters exceeded

Related questions

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 a 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 a comment
    10|10000 characters needed characters exceeded

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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.