--IF NOT EXISTS (SELECT * FROM [TALYASETUP].SYS.indexes WHERE [name] = N'IXAZ_LANGSENTD')
CREATE NONCLUSTERED INDEX [IXAZ_LANGSENTD] ON [TALYASETUP].[dbo].[LANGSENTD]
(
	[LANGSENTID] ASC,
	[LANGCODE] ASC
)
INCLUDE ( 	[TRANSLATION],
	[CTYPE])-- 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]
GO


--IF NOT EXISTS (SELECT * FROM [TALYASETUP].SYS.indexes WHERE [name] = N'IXAZ_LANGSENT_LAGSENTID_FORMNAME')

--CREATE NONCLUSTERED INDEX [IXAZ_LANGSENT_LAGSENTID_FORMNAME] ON [TALYASETUP].[dbo].[LANGSENT]
--(
--	[LANGSENTID] ASC,
--	[FORMNAME] ASC
--)
--INCLUDE ( 	[COMPNAME],
--	[LANGSENT]) 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


