Skip to Content
author's profile photo
Former Member

how to create SECONDARY INDEX?

how to create SECONDARY INDEX?

please explain

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 10:28 AM

    Hi,

    Index of database tables defined in the ABAP Dictionary. This index can be created in addition to the primary index. Creating secondary indices can improve performance when accessing databases that evaluate the indices of the database. A secondary database can be unique, but does not have to be.

    please check out the link below it will help you

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

    http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm

    **********please reward points if the information is helpful to you***********

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 10:28 AM
    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 10:28 AM

    Hi,

    Creating Secondary Indexes

    Procedure

    ...

    1. In the maintenance screen of the table, choose Indexes.

    If indexes already exist on the table, a list of these indexes is displayed. Choose .

    2. In the next dialog box, enter the index ID and choose

    The maintenance screen for indexes appears.

    3. Enter an explanatory text in the field Short text.

    You can then use the short text to find the index at a later time – for example through the Information System.

    4. Select the table fields to be inserted in the index using the input help for the Field name column.

    The order of the fields in the index is very important. See What to Keep in Mind for Secondary Indexes

    5. If the values in the index fields already uniquely identify each record of the table, select Unique index.

    A unique index is always created in the database at activation because it also has a functional meaning (prevents double entries of the index fields).

    6. If it is not a unique index, leave Non-unique index selected.

    In this case you can use the radio buttons to define whether the index should be created for all database systems, for selected database systems or not at all in the database.

    7. Select for selected database systems if the index should only be created for selected database systems.

    Click on the arrow behind the radio buttons. A dialog box appears in which you can define up to 4 database systems with the input help. Select Selection list if the index should only be created on the given database systems. Select Exclusion list if the index should not be created on the given database systems. Choose .

    8. Choose .

    Result

    The secondary index is automatically created on the database during activation if the corresponding table has already been created there and index creation was not excluded for the database system

    http://help.sap.com/saphelp_47x200/helpdata/en/cf/21eb20446011d189700000e8322d00/frameset.htm

    <b>Reward if helpful.</b>

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 20, 2007 at 10:32 AM

    goto se11 enter table name press display

    then u will find index push button in top of the table press it gi trough the navigation

    primary index created automatically at the time of table creation .

    to speed up data retrieval to support where clause in select statement for non primary key fields user has to create secondary idexes to improve performance

    regards

    Nagesh .Paruchuri.

    reward if u find useful

    Add comment
    10|10000 characters needed characters exceeded