Based on all of the SQL Server diagnostic reviews on Sage 500 that I have done over the past 10 years. These are some areas that I always see improvement when adding these indexes.

CREATE NONCLUSTERED INDEX [IX_RevrsCustPmtKey_CS]
ON [dbo].[tarCustPmt] ([RevrsCustPmtKey])
GO

-- For vdv Views

CREATE NONCLUSTERED INDEX [IX_CompanyID_CS]
ON [dbo].[tpoPurchOrderLog] ([CompanyID],[TranNo],[TranType])

GO

CREATE NONCLUSTERED INDEX [IX_CompnayID_CS]
ON [dbo].[timInvtTran] ([CompanyID],[TranNo],[TranType])

GO


CREATE NONCLUSTERED INDEX [IX_CompanyID_CS]
ON [dbo].[tpoReceiver] ([CompanyID],[TranNo],[TranType])

GO


CREATE NONCLUSTERED INDEX [IX_CompanyID_CS]
ON [dbo].[tsoSalesOrder] ([CompanyID],[TranNo],[TranType])

GO


CREATE NONCLUSTERED INDEX [IX_CompanyID_CS]
ON [dbo].[tarInvoice] ([CompanyID],[TranNo],[TranType])

GO


CREATE NONCLUSTERED INDEX [IX_JrnlKey_CS]
ON [dbo].[timPosting] ([JrnlKey])

GO


CREATE NONCLUSTERED INDEX [IX_InvtLotBinKey_CS]
ON [dbo].[timInvtTranDist] ([InvtLotBinKey])

GO

by: Joe N. | over a year ago | 6 - General Enhancements