USE MELALEUCA_TESTSITE

create unique index [ix_ML_sa_ss] on [ml]
(
	[sa_ss] asc
) ON [PRIMARY]


USE [SDKDW]
GO
CREATE NONCLUSTERED INDEX [ix_TBL_SDK_ML_LINE] ON [dbo].[TBL_SDK_ML_LINE] 
(
	[ord_no] ASC
) ON [PRIMARY]
GO


USE [SDKDW]
GO
CREATE NONCLUSTERED INDEX [ix_tbl_customer_cancellation_d2_item] ON [dbo].[TBL_Customer_Cancellation_D2] 
(
    [item] ASC,
    [sa_ss] asc
) ON [PRIMARY]
GO