Colleagues, Can anyone explain why for example in table dbo.Activity there are identical indexes 'I7Nk67FkcZJTOtRCb5pRNRHffI' and 'Iqf5Ij9PskG09b4gVMq7XcSq04g'? It hardly speeds up the work, but this functionality is directly present in the basic version of the product! There are about 50 such indexes in the database, and one is created by the system, the other is in the database. Therefore, it turns out that only one index works when searching, but when inserting there will already be two additional processing of these indexes. And this already significantly affects the speed of the application during the addition of records, and this is inherent in objects where are many records (Product, calls, contacts, activities). How to fix this problem?
Like
1 comments
12:41 Jan 20, 2022
Hello,
This double will not lead to system errors.
The extra index may have a small effect on adding records, but it shouldn't be significant.
For a faster solution, you can remove duplicate indexes manually.
We are investigating the possible reason for the appearance of such a duplicate.
We will fix this in one of the future versions, but there is no ETA.
Best regards,
Bogdan
Show all comments