help on index

[Former Member]

1)While creating secondary index is it mandatory to to gv atleast one primary key along with the feilds.

2)while deleting secondary index its showing like

Make repairs in foreign namespaces only if theyare urgent

an also maintain in orginal lang, maintain in logon lang.

which should i select an further it requies any acess key beacuse its not showing delete option in menu path...... plz help me out.

3) why do we create an secondary index? wts the use of it?

4)hw many secondary indexes can we create for a table(maximum)?

[former_member195698]

1) No, its not mandatory to give the primary key in the Secondary Index fields.

2) Select maintain in Original language. When you click on the secondary index button in SE11, it will give you a popup with the list of secondary indexes on the table. You can keep the cursor on the index and click the delete button. It will delete the index from the table.

3) You can search a table for data records that satisfy certain search criteria faster using an index.

An index can be considered a copy of a database table that has been reduced to certain fields. This copy is always in sorted form. Sorting provides faster access to the data records of the table, for example using a binary search. The index also contains a pointer to the corresponding record of the actual table so that the fields not contained in the index can also be read. It is required to create a secondary index if the table is frequently accessed in a way that does not take advantage of the sorting of the primary index for the access

Link on how to create secondary index.

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

Regards,

Abhishek

[Former Member]

It is generally a bad idea to create a secondary index on a standard SAP table. This is because of tablespace and performance issues for other online transactions. It's advisable to try to find an ABAP solution first. If you can post the SELECT you are trying to speed up, maybe we can help.

Rob