
CREATE NONCLUSTERED INDEX [IXM_ITS_DBILDIRIMID_TEMPTFISLID]
ON [dbo].[ITS] ([DBILDIRIMID],[TEMPTFISLID])
INCLUDE ([KAREKODU],[GTIN],[SN],[XD],[BN],[FATISLID],[ABILDIRIMID],[FBILDIRIMID],[FFATISLID],[DDEPOFISISLID],[DTDEPOFISISLID],[KTARIHI],[USERID],
        [FATID],[DEPOFISID],[ATARIH],[STARIH],[ITARIH],[TEMPFATISLID],[TEMPDFISLID],[TEMPIADEFATISLID],[SUBEID],[KULLANILDI])
		WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]

GO
