fact_data indexes

USE [FSTest]
GO

/****** Object:  Index [FACT_Data_z]    Script Date: 10/23/2017 11:43:11 AM ******/
CREATE NONCLUSTERED INDEX [FACT_Data_z] ON [dbo].[FACT_Data]
(
    [STime] ASC,
    [dept_id] ASC,
    [WrittenState] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FACT_Data]    Script Date: 10/23/2017 11:43:11 AM ******/
CREATE NONCLUSTERED INDEX [IX_FACT_Data] ON [dbo].[FACT_Data]
(
    [STime] ASC,
    [dept_id] ASC,
    [specs_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FACT_Data_DeptSpecSubg]    Script Date: 10/23/2017 11:43:11 AM ******/
CREATE NONCLUSTERED INDEX [IX_FACT_Data_DeptSpecSubg] ON [dbo].[FACT_Data]
(
    [dept_id] ASC,
    [specs_id] ASC,
    [subg_number] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FACT_DATA2]    Script Date: 10/23/2017 11:43:11 AM ******/
CREATE NONCLUSTERED INDEX [IX_FACT_DATA2] ON [dbo].[FACT_Data]
(
    [dept_id] ASC,
    [specs_id] ASC,
    [STime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FACT_DataSpecsTimeID]    Script Date: 10/23/2017 11:43:11 AM ******/
CREATE NONCLUSTERED INDEX [IX_FACT_DataSpecsTimeID] ON [dbo].[FACT_Data]
(
    [specs_id] ASC,
    [STime] ASC,
    [data_id] ASC,
    [data_uid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO