Changeset 13678


Ignore:
Timestamp:
03/10/16 10:13:08 (18 months ago)
Author:
abeham
Message:

#2586: added an index on StateLog and updated the index on RequiredPlugins to include additional columns

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql

    r12926 r13678  
    261261INSERT INTO [statistics].[DimUser] ([UserId], [Name])
    262262VALUES ('00000000-0000-0000-0000-000000000000', 'NULL');
     263
     264/****** Object:  Index [TaskIdStateLog]    Script Date: 03/10/2016 10:09:14 ******/
     265CREATE NONCLUSTERED INDEX [TaskIdStateLog] ON [dbo].[StateLog]
     266(
     267  [TaskId] ASC
     268)
     269INCLUDE ( [StateLogId],
     270[State],
     271[DateTime],
     272[UserId],
     273[SlaveId],
     274[Exception]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
     275GO
     276
     277/****** Object:  Index [Index_RequiredPlugins_TaskId]    Script Date: 03/10/2016 10:09:19 ******/
     278CREATE NONCLUSTERED INDEX [Index_RequiredPlugins_TaskId] ON [dbo].[RequiredPlugins]
     279(
     280  [TaskId] ASC
     281)
     282INCLUDE ( [RequiredPluginId],
     283[PluginId]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
     284GO
     285
     286
Note: See TracChangeset for help on using the changeset viewer.