---

-- Посмотреть индексы и их ключевые столбцы

SELECT

    DB_NAME() AS database_name,

    t.name AS table_name,

    i.name AS index_name,

    ic.key_ordinal,

    c.name AS column_name,

    ic.is_included_column

FROM sys.tables AS t

JOIN sys.indexes AS i

  ON i.object_id = t.object_id

JOIN sys.index_columns AS ic

  ON ic.object_id = i.object_id

 AND ic.index_id = i.index_id

JOIN sys.columns AS c

  ON c.object_id = ic.object_id

 AND c.column_id = ic.column_id

WHERE t.name IN (N'dat_activity', N'dat_members', N'sb_reports')

  AND i.index_id > 0

ORDER BY t.name, i.name, ic.is_included_column, ic.key_ordinal;  -- replTransVas
CREATE NONCLUSTERED INDEX IX_dat_activity_kodWave_kod
ON dbo.dat_activity (kodWave, kod)
INCLUDE (nmMerop, clsMerop);
GO

CREATE NONCLUSTERED INDEX IX_sb_reports_kodMember
ON dbo.sb_reports (kodMember)
INCLUDE (kodProject, kodSend);
GO

-- myNewVasya
CREATE NONCLUSTERED INDEX IX_dat_members_kodMerop_kod
ON dbo.dat_members (kodMerop, kod)
INCLUDE (timeInMerop);
GO