19 lines
986 B
Transact-SQL
19 lines
986 B
Transact-SQL
--Migration
|
|
|
|
IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = N'IX_ORARENDIORA_OSZTALYCSOPORTID_INTEZMENYID_TANEVID_HETNAPJA_ORAERVENYESSEGKEZDETE_ORAERVENYESSEGVEGE_HETIREND' AND OBJECT_NAME([object_id]) = N'T_ORARENDIORA') BEGIN
|
|
CREATE NONCLUSTERED INDEX IX_ORARENDIORA_OSZTALYCSOPORTID_INTEZMENYID_TANEVID_HETNAPJA_ORAERVENYESSEGKEZDETE_ORAERVENYESSEGVEGE_HETIREND
|
|
ON dbo.T_ORARENDIORA (C_OSZTALYCSOPORTID, C_INTEZMENYID, C_TANEVID, C_HETNAPJA, C_ORAERVENYESSEGKEZDETE, C_ORAERVENYESSEGVEGE, C_HETIREND)
|
|
INCLUDE (C_CSENGETESIRENDID)
|
|
WHERE TOROLT = 'F'
|
|
END
|
|
GO
|
|
|
|
IF NOT EXISTS (SELECT 1 FROM sys.indexes WHERE name = N'IX_TANITASIORA_DATUM_OSZTALYCSOPORTID_TANEVID_INTEZMENYID' AND OBJECT_NAME([object_id]) = N'T_TANITASIORA') BEGIN
|
|
CREATE NONCLUSTERED INDEX IX_TANITASIORA_DATUM_OSZTALYCSOPORTID_TANEVID_INTEZMENYID
|
|
ON dbo.T_TANITASIORA (C_DATUM, C_OSZTALYCSOPORTID, C_TANEVID, C_INTEZMENYID)
|
|
INCLUDE (C_CSENGETESIRENDID)
|
|
WHERE TOROLT = 'F'
|
|
END
|
|
GO
|
|
|