INDEXES Urgent

[Former Member]

CAN I ADD INDEX ON GJAHR PERIO FIKRS BUKRS IN the table FMIOI if

these are NOT key fields????

fmioi

[Former Member]

You could,

Click On INDEXES in SE11... Give it a name (z*) and add your fields.

Message was edited by:

Gunther OLTRA

[Former Member]

Primary index is created by default on the database when the table is activated. Primary index contains the primary keys of the table.

Secondary indexes are user defined indexes and are created on need basis to facilitate faster access to database tables.

So u can add secondary index.

REGARDS

VASU

[varma_narayana]

Hi Julia..

We can create a Secondary index with these fields (GJAHR PERIO FIKRS BUKRS)

on this table FMIOI.

Tcode SE11:

Enter the Table FMIOI.

Click on Display.

Now select the INDEXes button on the Toolbar .

Create and Activate the index (Eg: Zx1)

REWARD IF HELPFUL.

[paruchuri_nagesh]

you can create secondary indexes on the non primary key fields

its speed up data retrieving

regards

Nagesh.Paruchuri