IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[HTETKIKKART]') AND name = N'IX_HTETKIKKART_HDOSYAID_HKIMLIKID_UYGBIRIMID_UYGBOLUMID_UYGKURUMID_SNKAYITID_GIRISTARIH_HTETKIKKARTID')
BEGIN
    CREATE NONCLUSTERED INDEX [IX_HTETKIKKART_HDOSYAID_HKIMLIKID_UYGBIRIMID_UYGBOLUMID_UYGKURUMID_SNKAYITID_GIRISTARIH_HTETKIKKARTID] ON [dbo].[HTETKIKKART]
    (
	    [HDOSYAID] ASC,
	    [HKIMLIKID] ASC,
	    [UYGBIRIMID] ASC,
	    [UYGBOLUMID] ASC,
	    [UYGKURUMID] ASC,
	    [SNKAYITID] ASC,
	    [GIRISTARIH] ASC,
	    [HTETKIKKARTID] ASC
    )
    INCLUDE ( 	[RAPOR],
	    [ACIKLAMA],
	    [ILKGIRISTRH],
	    [ACIL],
	    [TKSONUCTARIHI],
	    [BIRIMSIRANO],[TKIPTAL],[TETKIKONCELIKLIHASTA]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = ON, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
END