How to remove out of the box index from a custom shcema permanently. | Community
Skip to main content
A
AbhiSr
Level 2
March 24, 2021
Question

How to remove out of the box index from a custom shcema permanently.

  • March 24, 2021
  • 3 replies
  • 1749 views

I wan to remove out of the box index from my customized schema. When I do that using DROP Index script,the index gets removed but whenever I do a update database structure on that schema, the indexes gets added again. Is there a way to remove the out of the box indexes permanently?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe Employee
Adobe Employee
March 24, 2021

Hi Abhijeet,

 

Can you provide us with an understanding of the use case as to why you'd want to remove the indexes on the OOTB schemas? Those indexes have been added for performance reasons and it isn't recommended to remove these.

 

Additionally can you tell us which schemas and which indexes you are trying to remove?

 

Thanks,

Craig

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    March 31, 2021

    Hi @abhisr,

    Were you able to resolve this query or do you still need more help here? Do let us know.

    Thanks!

    Sukrity Wadhwa
    D
    DebTr
    Level 6
    March 31, 2021

    Hi @abhisr ,

    Pls can you put some pseudo code to explain this?

     

    Thanks,

    Deb

    P
    PLundmark
    Level 2
    October 19, 2022

    I'm considering removing a few of the indexes from the recipient table of ACC due to bloat and general space usage. 

     

    The indexes I'm considering deleting are: 
    @2362510 - since the field is not in use

    @3583986 - since the field is not in use

    @2503248 - since there are 2 indexes where one is searchFromStart which I'd keep

    @lastName - see firstName

     

    //Peter

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    November 2, 2022

    Hey @craig_thonis,

    Could you please help @plundmark further here?

    Thanks!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...