Problem while creating secondary Index

[former_member767623]

Hi to All,

I have to create a secondary index for improve the performance of one report. I created and activated though this warning (Index does not exist in database system) is coming.

1) Is this mean that the secondary index is created or not.

2) Why it is not coming like Index EKBE~PLA exists in database system ORACLE.

Any one please explain in detail with steps.

Thanks in advance.

Regards,

Radhakrishna.Ette

Moderator Message: <subject altered>...Please do not post the subject in CAPS and let it be more descriptive

Message was edited by: Kesavadas Thekkillath

[Former Member]

First - Create Secondary index in customer namespace.

Second - STOP. Don't create a secondary index on standard table for a single report performance issue.

Creating a secondary index consumes memory, and also, might have performance impact on standard functionality.

Be very careful and very very confident that you need to create the secondary index.

Most of the times, you need to change the custom code to improve the performance, and it will solve the issue.

Anyway.

The index is not created.

Is your index active? What is the status of your index? Can you give a screenshot?

[Former Member]

Hi,

Secondary index gets created when you activate a table.

Try adjusting the database (SE14) and check whether this will solve it.

You can also got DB02 and check the Diagnostics->Missing Table and Indexes.

Find you index and Press 'Create on DB'.

Hope this will help.

Thanks,

Shambu

[former_member767623]

Hi Shaym,

It i have done by DB02--->Diagonostics--->Missing tables and indexes--->secondary indexes

Here i have find my index, It beside icon with Create to DB Just activated it , my prob is solved

Thanq