Share
Report
16Hello, 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]) |
All responses (
Answers (
