Skip to main content
Suggested answer

Creating SQL table indexes to improve performance

editSubscribe (0) ShareShare
ReportReport
Posted on by 16
Hello, what are the Pros and Cons to adding them (for GP 18.5)?
Anyone experience any issues?
 
fyi we just upgraded GP so another upgrade is unlikely for years
 
 
CREATE INDEX [idx_iic_GL30000_001] ON [IIC01].[dbo].[GL30000] ([ACTINDX]) INCLUDE ([JRNENTRY], [SOURCDOC], [REFRENCE], [DSCRIPTN], [TRXDATE], [ORGNATYP], [SERIES], [DEBITAMT], [CRDTAMNT])
CREATE INDEX [idx_iic_IV00200_001] ON [IIC01].[dbo].[IV00200] ([SERLNMBR], [SERLNSLD])
CREATE INDEX [idx_iic_SOP10104_001] ON [IIC01].[dbo].[SOP10104] ([SOPNUMBE], [DELETE1],[PRCHLDID]) INCLUDE ([USERID], [HOLDDATE], [TIME1])
CREATE INDEX [idx_iic_SOP10201_001] ON [IIC01].[dbo].[SOP10201] ([SOPNUMBE]) INCLUDE ([LNITMSEQ], [SERLTNUM], [DATERECD], [BIN])
CREATE INDEX [idx_iic_SOP10201_002] ON [IIC01].[dbo].[SOP10201] ([SOPTYPE]) INCLUDE ([SOPNUMBE], [LNITMSEQ], [SERLTNUM])
CREATE INDEX [idx_iic_SOP30200_001] ON [IIC01].[dbo].[SOP30200] ([DOCDATE]) INCLUDE ([SOPTYPE], [SOPNUMBE], [DOCID], [QUOEXPDA], [ReqShipDate], [BCHSOURC], [BACHNUMB], [CUSTNMBR], [CUSTNAME], [CSTPONBR], [PROSPECT], [PRSTADCD], [DOCAMNT], [SLPRSNID], [VOIDSTTS], [ALLOCABY], [CURNCYID], [SOPSTATUS], [SHIPCOMPLETE], [WorkflowPriorityCreditLm], [WorkflowPriorityQuote])
CREATE INDEX [idx_iic_SOP60100_001] ON [IIC01].[dbo].[SOP60100] ([SOPNUMBE], [LNITMSEQ]) INCLUDE ([SOPTYPE], [GLPOSTDT])
 
CREATE INDEX [idx_iic_Trigger_001] ON [ManagementReporter].[Scheduling].[Trigger] ([StartBoundary]) INCLUDE ([Id], [Type], [UnitOfMeasure], [IsEnabled], [EndBoundary], [RecurrenceLimit], [Interval], [DaysOfWeek], [DayOfMonth], [WeekOfMonth], [MonthOfYear], [OnlyWeekday], [TimeZoneId], [RunImmediately], [Version])