topic Re: how to create secondry index on database table in Application Development and Automation Discussions

how to create secondry index on database table

Former Member — Thu, 21 Sep 2006 06:26:30 GMT

how to create secondry index on database table

Re: how to create secondry index on database table

Former Member — Thu, 21 Sep 2006 06:33:06 GMT

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

Re: how to create secondry index on database table

Former Member — Thu, 21 Sep 2006 06:33:07 GMT

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

Re: how to create secondry index on database table

Former Member — Thu, 21 Sep 2006 06:34:13 GMT

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

Re: how to create secondry index on database table

Former Member — Thu, 21 Sep 2006 06:46:37 GMT

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