Changeset 6972


Ignore:
Timestamp:
11/08/11 15:25:58 (11 years ago)
Author:
ascheibe
Message:

#1233 added indices to DB script

File:
1 edited

Legend:

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

    r6958 r6972  
    232232GO
    233233
    234 -- =============================================
    235 -- Author:    cneumuel
    236 -- Create date: 17.05.2011
    237 -- Description: Writes the execution times of deleted Tasks into DeletedJobStats to ensure correct statistics
    238 -- =============================================
    239 --CREATE TRIGGER [dbo].[tr_DeletedJobStats] ON [dbo].[Task] AFTER DELETE AS
    240 --BEGIN
    241 
    242 
    243 --END
    244 --GO
     234-- ============================================================
     235-- Description: Create indices to speed up execution of queries
     236-- ============================================================
     237
     238-- speed up joins between Job and Task
     239CREATE NONCLUSTERED INDEX [TaskJobIdIndex]
     240ON [dbo].[Task] ([JobId])
     241INCLUDE ([TaskId],[TaskState],[ExecutionTimeMs],[LastHeartbeat],[ParentTaskId],[Priority],[CoresNeeded],[MemoryNeeded],[IsParentTask],[FinishWhenChildJobsFinished],[Command],[IsPrivileged])
     242GO
     243
     244-- this is an index to speed up the GetWaitingTasks() method
     245CREATE NONCLUSTERED INDEX [TaskGetWaitingTasksIndex]
     246ON [dbo].[Task] ([TaskState],[IsParentTask],[FinishWhenChildJobsFinished],[CoresNeeded],[MemoryNeeded])
     247INCLUDE ([TaskId],[ExecutionTimeMs],[LastHeartbeat],[ParentTaskId],[Priority],[Command],[JobId],[IsPrivileged])
     248GO
Note: See TracChangeset for help on using the changeset viewer.