how to create secondry index on database table

[Former Member]

how to create secondry index on database table

[Former Member]

how to create secondry index on database table

[Former Member]

Hi

By trx SE11:

- Choose your table and press CHANGE ICON, so INDEX

When you create an index you should consider if your index is contained in another index.

If the fields of your index are:

- FIELD1, FLIED2, FIELD3

...it'll be triggered only if the select is:

SELECT * FROM <TABLE> WHERE FIELD1

AND FIELD2

AND FIELD3

A select like this

SELECT * FROM <TABLE> WHERE FIELD1

AND FIELD3

AND FIELD2

doesn't use your index.

Max

[Former Member]

You can just create it via SE11. No need to have Basis involved, but I would make them aware of it. It really depends on your procedures. Are you supposed to make them aware? Is this for a custom DB, or a standard SAP table. If it is a standard SAP table, I would suggest making them aware, so that they can monitor any spikes in performance during UPDATES.

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

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

[Former Member]

Hello,

1,In SE11 Transaction display your table.

2.press button index... in tool bar, it will ask you

to create a new one.

3.give the index name

4. give short text description

5. in bottom table give the field name on which

you want index.

6. save and activate.

Regards

[Former Member]

Hello,

Go to transaction SE11 in change mode. Click the button INDEXES on the top. Just continue with the navigation till you create index for a field. Save and Activate the table.

Regs,

Venkat Ramanan N