Very slow "Reading Indexes"

mfc2mfc2

Why does my SQL Compare 14.2.9.15508 take multiple minutes to read indexes when comparing two SQL Server 2019 databases? The rest of the process is quick, but reading indexes is painfully slow. I tried the Ignore Indexes option in the settings, but that does not help.

Dan_J

Hi @mfc2mfc2

Thanks for reaching out to us regarding this.

SQL Compare can spend a lot more time reviewing indexes than on the rest of the comparison process, the time taken can be impacted by the number of dependencies upon them.

I think it would be worth updating SQL Compare to the latest version (14.4.8) to see if that has a positive impact on the time taken to review/compare the indexes. You can download this version here: https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_14.4.8.17007.exe 

I hope this helps, however please don't hesitate in reaching out to us again if you require any further assistance on this.