Share
ReportHello, 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]) |
Categories:
All responses (
Answers (
