Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Level 1
AbhijeetSrivastava
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
AbhijeetSrivastava
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
AbhijeetSrivastava
Level 1

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
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

256 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

167 likes

Total Posts

256 posts

Correct Reply

152 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
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
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct Reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile

Avatar
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct Reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile
Deb007
Level 4

31-03-2021

Hi @AbhijeetSrivastava ,

Pls can you put some pseudo code to explain this?

 

Thanks,

Deb

Avatar

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

140 likes

Total Posts

856 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

140 likes

Total Posts

856 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile
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!