Question

Same indexes in one table

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 0

Like

1 comments

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