Skip to Content

SPDD Reset as original on a table index

Hello,

We have SAP tables with added indexes that are detected by SPDD

as an index creation is considered as a modification.

If I choose reset as original or accept proposal, the result is the same.

The index is preserved as far as I have seen.

1. Is there a difference that I have missed?

From my understanding, reset as original should remove the modification.

In this case the created index is considered as a modification.

2. Why is it not deleted if I choose reset as original?

Thanks in advance for your answer.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 07, 2013 at 08:05 AM

    Without seeing the SPPD output, the starting Support Pack / Stack, the target Support Pack / Stack level and so on, I can't be too definite, but ....

    It could be as simple as the creation of the index being in response to an OSS correction that is now incorporated in the Support Packs you've just implemented. I've seen similar results when people make changes manually rather than using SNOTE.

    hth

    Add comment
    10|10000 characters needed characters exceeded

    • You are saying that SP 12 has created this index.

      I'm saying that in SPDD you can see a new version of the index created by the SP.

      How can you ensure that Z1 delivered by SAP is identical to our current Z1?

      Is it because you have unchanged in general attributes and in Fields?

      The image shows a comparison between the two versions of the indexes.

      Regards, Juan

  • avatar image
    Former Member
    May 07, 2013 at 07:27 AM

    Why you created this index? Can you provide sceenshot from SPDD?

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Roman,

      Roman N wrote:

      Why you created this index? Can you provide sceenshot from SPDD?

      These indexes dates from 2004.

      It is a developer that has created them.

      As I am not this developer, I can only guess why he has created:

      He thought that he could do much better tuning than SAP by noticing

      a bad query plan in st05.

      I think he did not realize the possible bad impacts of creating a index.

      But this is another question :-)

      I do not have a screen shot of the SPDD.

      But it just shows the table and the associated indexes.

      Which other details would you like?

      My question 1. and 2. are still open.

      Regards,

  • avatar image
    Former Member
    May 07, 2013 at 08:27 AM
    Add comment
    10|10000 characters needed characters exceeded