Can we create a database index?

[Former Member]

Hi all..

Can we create a database index for a customised table? and later on can we change the same database index?

Also if possible please provide me with a suitable link for this topic.

Thanks

[Former Member]

Hi all..

Can we create a database index for a customised table? and later on can we change the same database index?

Also if possible please provide me with a suitable link for this topic.

Thanks

[Former Member]

hi,

use <b>SE14</b>

enter the table name..

click on the index button.. or in the menu.

regards

satesh

[Former Member]

Yes we can create indexes and recreate them...

Just open the table in SE11 and in menu...

Go to -> Index

Click on New.

Check the fields based on which an index is to be created and Activate..

Regards,

Wenceslaus.

[Former Member]

Hello Wenceslaus.

Thanks for the answer. Its very helpful.

But do we need any special kind of authorization for creating a database index.?

[Former Member]

Hi Subhash,

Just try these two links which will let you know about the authorization and creation of indexes.

http://dev.mysql.com/doc/maxdb/en/cd/adf27ab99711d6b2a300508b6b8a93/content.htm

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

Cheers

Sunny

[Former Member]

HI

PLEASE REFER THE LINKS

1 <a href="http://72.14.203.104/search?q=cache:cHuHvVv9UfgJ:help.sap.com/saphelp_nw04/helpdata/en/cf/21f0f0446011d189700000e8322d00/content.htm+adatabaseindexIN+ABAP&hl=en&gl=in&ct=clnk&cd=1">Editing Tables and Indexes in the Database</a>

2 <a href="http://72.14.203.104/search?q=cache:mIR0TLmS_fsJ:help.sap.com/saphelp_nw04/helpdata/en/cf/21eb20446011d189700000e8322d00/content.htm+adatabaseindexIN+ABAP&hl=en&gl=in&ct=clnk&cd=2">Indexes</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm">Creating Secondary Indexes</a>

IF THESE ARE USEFUL PLEASE REWARD POINTS

REGARDS

ANOOP

Message was edited by: ANOOP R.S

[Former Member]

Hi Subhash,

1 ) For an index to create , You have the necessary user authorizations and the user attribute NOT EXCLUSIVE.

2) Indexes provide access to the table data using non-key columns plus If duplicate keys have already been inserted in the table, it is no longer possible to create the index. You must identify the incorrect keys and delete them.

3) Having Multiple index on the same table will also effect the performance.

You can create your own index also keeping in mind the above points from SE11 as suggested above.

Cheers

Sunny

Rewrd points, if found helpful

[Former Member]

Hi,

Just checked it out...

You can create indexes for Z* tables without authorizations

For standard tables:

When you create an index you have to have authorizations.

You must send some Workbench Requests.

Else you can ask your Basis team to create indexes on the table.

Regards,

Wenceslaus.

[Former Member]

Thanks again Wenceslaus..

[Former Member]

Hi,

You cannot change a database index for a table as long as you have data in the table. You will have to delete the index and recreate it.

You should go to se14 transaction to activate your changes made to the structure of the table.

Regards,

Anjali