Changeset 6972 for branches/HeuristicLab.Hive-3.4

Timestamp:

11/08/11 15:25:58 (12 years ago)

Author:

ascheibe

Message:

#1233 added indices to DB script

File:

• branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql (modified) (1 diff)

branches/HeuristicLab.Hive-3.4/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql

@@ -232 +232 @@
 GO
 
--- =============================================
--- Author:    cneumuel
--- Create date: 17.05.2011
--- Description: Writes the execution times of deleted Tasks into DeletedJobStats to ensure correct statistics
--- =============================================
---CREATE TRIGGER [dbo].[tr_DeletedJobStats] ON [dbo].[Task] AFTER DELETE AS
---BEGIN
-
-
---END
---GO
+-- ============================================================
+-- Description: Create indices to speed up execution of queries
+-- ============================================================
+
+-- speed up joins between Job and Task
+CREATE NONCLUSTERED INDEX [TaskJobIdIndex]
+ON [dbo].[Task] ([JobId])
+INCLUDE ([TaskId],[TaskState],[ExecutionTimeMs],[LastHeartbeat],[ParentTaskId],[Priority],[CoresNeeded],[MemoryNeeded],[IsParentTask],[FinishWhenChildJobsFinished],[Command],[IsPrivileged])
+GO
+
+-- this is an index to speed up the GetWaitingTasks() method 
+CREATE NONCLUSTERED INDEX [TaskGetWaitingTasksIndex]
+ON [dbo].[Task] ([TaskState],[IsParentTask],[FinishWhenChildJobsFinished],[CoresNeeded],[MemoryNeeded])
+INCLUDE ([TaskId],[ExecutionTimeMs],[LastHeartbeat],[ParentTaskId],[Priority],[Command],[JobId],[IsPrivileged])
+GO