/*
** Copyright (C) 2014 independIT Integrative Technologies GmbH
*/

CREATE INDEX SME2LOAD_IDX ON SME2LOAD ([ID]);
go
CREATE INDEX SME_IDX ON SUBMITTED_ENTITY ([MASTER_ID], [ID], [STATE], [FINAL_TS]);
go
CREATE INDEX KILL_JOB_IDX ON KILL_JOB ([SME_ID]);
go
CREATE INDEX AUDIT_TRAIL_IDX ON AUDIT_TRAIL ([OBJECT_ID]);
go
CREATE INDEX ENTITY_VARIABLE_IDX ON ENTITY_VARIABLE ([SME_ID]);
go
CREATE INDEX DEPENDENCY_INSTANCE_IDX ON DEPENDENCY_INSTANCE ([DEPENDENT_ID]);
go
CREATE INDEX HIERARCHY_INSTANCE_IDX ON HIERARCHY_INSTANCE ([CHILD_ID]);
go
