topic Problem while creating secondary Index in Application Development and Automation Discussions

Problem while creating secondary Index

former_member767623 — Tue, 26 Jun 2012 08:02:35 GMT

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

Re: Problem while creating secondary Index

Former Member — Tue, 26 Jun 2012 08:41:09 GMT

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?

Re: Problem while creating secondary Index

Former Member — Tue, 26 Jun 2012 09:39:37 GMT

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

Re: Problem while creating secondary Index

former_member767623 — Tue, 26 Jun 2012 10:05:56 GMT

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