topic Re: tables in Application Development and Automation Discussions

tables

Former Member — Tue, 01 May 2007 08:49:48 GMT

how we have to create secondary indices ?

Re: tables

Former Member — Tue, 01 May 2007 08:51:29 GMT

Hi,

In the maintenance screen of the table, choose Indexes.

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

In the next dialog box, enter the index ID and choose ok

The maintenance screen for indexes appears.

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 with the R/3 Repository Information System.

Select the table fields to be included 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.

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).

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.

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 ok.

Choose Activate

Regards

Sudheer

Re: tables

Former Member — Tue, 01 May 2007 08:52:25 GMT

Hi!

You can simply create secondary indexes for DDIC tables, using transaction SE11.

Regards

Tamá

Re: tables

Former Member — Tue, 01 May 2007 08:53:27 GMT

hi,

go to se11->display->indexes

u can find there option to create indexes.

Rewards point if helpful

Regards

Santosh

Re: tables

Former Member — Tue, 01 May 2007 08:53:30 GMT

Hi Pinky,

<b>

Very useful link on creating Secondary indexes:</b>

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

<b>

Reward all helpful answers</b>

Regards,

V.Raghavender.

Re: tables

Former Member — Tue, 01 May 2007 08:54:16 GMT

Hi pinky,

Simple.

1. It is created using tcode SE11.

2. Goto se11, choose any table, and display

3. On the application toolbar, choose button INDEXES.

4. It will display the existing index if they are.

On that window, now u can choose CREATE and proceed further.

regards,

amit m.

Re: tables

alison_lloyd — Tue, 01 May 2007 08:56:41 GMT

Make sure you actually need the index and that it will not have a negative impact on overall performance. Check with the basis team before creating. Also check that when created it is actually created on the database otherwise it will not imp,rove your performance.