Skip to Content
author's profile photo Former Member
Former Member

Missing indexses in DB02

Hi ,

When i am monitoring the system thru DB02 i m getting missing secondary indexses.....can anyone tell me why they actually come? how severe can they for the system? how can i adjust them?

The name of the indexes are

/BIC/FITC_MDP-020

/BIC/FITC_MDP-030

/BIC/FITC_MDP-040

/BIC/FITC_MDP-050

/BIC/FITC_MDP-060

/BIC/FITC_MDP-070

and as a matter of fact i have run abap report

SAP_INFOCUBE_INDEXES_REPAIR

though running it has repaired some indexes but not the one i want.plz suggest

siddharth

regards

Message was edited by:

Siddharth Sharma

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 12:57 AM

    Hi,

    More details...

    1. Use trx SE14

    2. Fill the table name: example: /BIC/FITC_MDP

    3. Click on EDIT

    4. Click on INDEX

    5. Select the index: example: /BIC/FITC_MDP-020

    6. Click on Delete index

    7. Click on Create index

    Another way:

    1. Use trx DB02

    2. Click on missing index

    3. Select the index

    4. Click on Create on DB

    Cristian

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2007 at 03:32 AM

    Hello Siddharth,

    Kindly go to SE38 execute RSANAORA program.

    Next screen select index and insert these indices and execute.

    These indices will be rebuilt.

    Thanks & Regards

    Vivek

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2007 at 07:21 AM

    Hello Siddharth,

    First, you have to check and search for the index already exists or not :

    Through OS level :-

    (sqlplus under sapr3 user)

    select index_name, owner, num_rows from dba_indexes

    where index_name = ' ' ;

    you can rather ALTER or REBUILD it using

    alter index sapr3." ~0" rebuild ;

    Regards,

    Jafer

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 11, 2007 at 06:51 PM

    Hi Siddartha,

    Since this is a BW system(guessing from the table name), it is possible that indexes are dropped during the data load into the Infocube and during the time, when you checked, they appeared as missing Indexes.

    In this case, suggest you to check the indexes once the load to the Infocube is completed.

    Regards

    Tanuj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 12:52 AM

    Use the trx SE14... select index and click on create.

    Cristian

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.