﻿DROP INDEX IF EXISTS [NCI_Cim_IntezmenyId_TanevId_KozteruletJellege] ON [dbo].[T_CIM]
GO

CREATE NONCLUSTERED INDEX [NCI_Cim_IntezmenyId_TanevId_KozteruletJellege] ON [dbo].[T_CIM]
(
	[C_INTEZMENYID] ASC,
	[C_TANEVID] ASC,
	[C_KOZTERULETJELLEGENEV] ASC
)
GO

DROP INDEX IF EXISTS [NCI_IntezmenyAdatok_IntezmenyId_TanevId_KozteruletJelleg] ON [dbo].[T_INTEZMENYADATOK]
GO

CREATE NONCLUSTERED INDEX [NCI_IntezmenyAdatok_IntezmenyId_TanevId_KozteruletJelleg] ON [dbo].[T_INTEZMENYADATOK]
(
	[C_INTEZMENYID] ASC,
	[C_TANEVID] ASC,
	[C_KOZTERULETJELLEGENEV] ASC
)
GO

DROP INDEX IF EXISTS [NCI_MukodesiHely_IntezmenyId_TanevId_KozteruletJelleg] ON [dbo].[T_MUKODESIHELY]
GO

CREATE NONCLUSTERED INDEX [NCI_MukodesiHely_IntezmenyId_TanevId_KozteruletJelleg] ON [dbo].[T_MUKODESIHELY]
(
	[C_INTEZMENYID] ASC,
	[C_TANEVID] ASC,
	[C_KOZTERULETJELLEGENEV] ASC
)
GO

DROP INDEX IF EXISTS [NCI_Nebulo_IntezmenyId_TanevId_TKKozteruletJellege] ON [dbo].[T_NEBULO]
DROP INDEX IF EXISTS [NCI_Nebulo_IntezmenyId_TanevId_TKKozteruletJellege2] ON [dbo].[T_NEBULO]
DROP INDEX IF EXISTS [NCI_Nebulo_IntezmenyId_TanevId_THKozteruletJellege] ON [dbo].[T_NEBULO]
DROP INDEX IF EXISTS [NCI_Nebulo_IntezmenyId_TanevId_KozteruletJellege] ON [dbo].[T_NEBULO]
GO