Sage 500

Recently our GL Trial Balance report became slow. We have a bit over 3.6 million rows in tglTransaction. We found that SQL Server 2012 stopped using an index which killed performance. We ended up adding a hint to use index(XIE1tglTransaction). If your…