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

Avatar

Avatar

AbhijeetSrivastava

Avatar

AbhijeetSrivastava

AbhijeetSrivastava

23-03-2021

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?

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar

craigthonis

Employee

Avatar

craigthonis

Employee

craigthonis
Employee

24-03-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

Avatar

Avatar

Deb007

Avatar

Deb007

Deb007

31-03-2021

Hi @AbhijeetSrivastava ,

Pls can you put some pseudo code to explain this?

 

Thanks,

Deb

Avatar

Avatar

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

31-03-2021

Hi @AbhijeetSrivastava,

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

Thanks!