USE [RDS_DataImport];
GO

IF EXISTS (SELECT name FROM sys.indexes
            WHERE name = N'IX_PERS_EMPLID')
    DROP INDEX IX_PERS_EMPLID ON CC_PERSONAL_DIM;
GO
CREATE INDEX IX_PERS_EMPLID ON CC_PERSONAL_DIM (PERS_EMPLID);
GO

IF EXISTS (SELECT name FROM sys.indexes
            WHERE name = N'IX_PERS_CAMPUS_ID')
    DROP INDEX IX_PERS_CAMPUS_ID ON CC_PERSONAL_DIM;
GO
CREATE INDEX IX_PERS_CAMPUS_ID ON CC_PERSONAL_DIM (PERS_CAMPUS_ID);
GO

IF EXISTS (SELECT name FROM sys.indexes
            WHERE name = N'IX_STRUC_EMPLID')
    DROP INDEX IX_STRUC_EMPLID ON REC_ACAD_STRUCTURE_DIM;
GO
CREATE INDEX IX_STRUC_EMPLID ON REC_ACAD_STRUCTURE_DIM (STRUC_EMPLID);
GO


IF EXISTS (SELECT name FROM sys.indexes
            WHERE name = N'IX_CTERM_EMPLID')
    DROP INDEX IX_CTERM_EMPLID ON REC_STUDENT_TERM_DIM;
GO
CREATE INDEX IX_CTERM_EMPLID ON REC_STUDENT_TERM_DIM (CTERM_EMPLID);
GO