alter table [dbo].tti_part_di
    add prem_internet_ind [nvarchar](1) NULL,
    mfr_product_nbr [nvarchar](30) NULL
    go


IF  EXISTS (SELECT *
FROM sys.indexes
WHERE name='part_di_system' AND object_id = OBJECT_ID('[dbo].tti_part_di'))
    DROP INDEX [part_di_system] ON [dbo].[tti_part_di]
GO

IF  EXISTS (SELECT *
FROM sys.indexes
WHERE name='part_di_mfr_system' AND object_id = OBJECT_ID('[dbo].tti_part_di'))
    DROP INDEX [part_di_mfr_system] ON [dbo].[tti_part_di]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [part_di_system]    Script Date: 7/26/2021 2:18:12 PM ******/
CREATE NONCLUSTERED INDEX [part_di_system] ON [dbo].[tti_part_di]
(
    [system_id] ASC,
    [tti_product_number] ASC,
    [tti_product_v_code] ASC,
    [warehouse_location] ASC

)

CREATE NONCLUSTERED INDEX [part_di_mfr_system] ON [dbo].[tti_part_di]
(
    [system_id] ASC,
    [mfr_product_nbr] ASC,
    [warehouse_location] ASC,
    [tti_product_v_code] ASC

)

WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF)
GO