Unable to Create database index

[Former Member]

Hello All,

I have a table where I'm trying to define indexes.

I make the additional entry for indexes via SE11.

Call transaction SE11.

Enter the table ..

Choose "Change".

Choose "Indexes ...".

Choose the "Create Index" icon and enter the table name and the index name.

However when I goto SE14 to create in the database, ->

Choose "Edit".

Choose "Indexes ...".

Select the index.

Choose continue.

-> Select 'Background' as the processing type.

> Choose "Create database index".

Here, I'm unable to te database index just because it is grayed out.

I tried with user DDIC also.

Can any one help with the reason that I am unable to create it.

Thanks a lot in advance.

Regards,

Pradeep

[Former Member]

Hello All,

I have a table where I'm trying to define indexes.

I make the additional entry for indexes via SE11.

Call transaction SE11.

Enter the table ..

Choose "Change".

Choose "Indexes ...".

Choose the "Create Index" icon and enter the table name and the index name.

However when I goto SE14 to create in the database, ->

Choose "Edit".

Choose "Indexes ...".

Select the index.

Choose continue.

-> Select 'Background' as the processing type.

> Choose "Create database index".

Here, I'm unable to te database index just because it is grayed out.

I tried with user DDIC also.

Can any one help with the reason that I am unable to create it.

Thanks a lot in advance.

Regards,

Pradeep

[Former Member]

Hello,

on which table you are trying to define an additional index ?

Regards Wolfgang

[MichaelTe]

Hello Pradeep,

does the index already exists in the database (visible via the text under the status field in se14)?

If yes, you have to press the button "Activate and adjust database".

Regards, Michael

[Former Member]

Hello Pradeep Cherian ,

As soon as you are done with the SE11 Index creation . You are done with the index creation. When you activate the Index that will create the database index by default. You don't need to create database index in SE14. that is the reason you are seeing the greayed out button in SE14.

You need to activate and adjust the database. That's it.

Hope this answers your question.

Thanks,

Greetson

[ShyamPindiproli]

Hello Pradeep,

Steps to create an Index

1. Goto SE11

2. Enter table name and F6(Change)

3. Select "Indexes" from the Application Tool bar

4. Select "Create Index" Option

5. Select one option

"Non-Unique index"

or

"Unique Index"

In case of a Non-Unique Index, 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.

Check the proper Type of the Index in SE11 again. This should solve your problem.

Regards,

Subrahmanya P

[venkat_ramana12]

The steps which you have followed are correct..

Call transaction SE11.

Enter the table ..

Choose "Change".

Choose "Indexes ...".

Choose the "Create Index" icon and enter the table name and the index name(with unique or non-unique).

By this time index will be created for the table.

after this you are doing the same steps in SE14 which are not required.

If you are not able to see the newly created index you just

goto the TCODE SE14 and give the table then click on "Activate and adjust database".

Hope this will help you.