Create index examples in SQL

USE [HawaiianAirlines_Analytics]
GO

/****** Object:  Index [IX_Custom_ReportKeyIndex]    Script Date: 1/19/2016 10:49:27 AM ******/
CREATE NONCLUSTERED INDEX [IX_Custom_ReportKeyIndex] ON [dbo].[Visits]
(
[VisitId] ASC,
[MultiSite] ASC,
[VisitorId] ASC,
[UserAgentId] ASC,
[LocationId] ASC,
[StartDateTime] ASC,
[EndDateTime] ASC
)
INCLUDE ( [Value]) 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

================================

USE [HawaiianAirlines_Analytics]
GO

/****** Object:  Index [IX_Custom_VisitorId_DateTime_TagName]    Script Date: 1/19/2016 10:24:50 AM ******/
CREATE NONCLUSTERED INDEX [IX_Custom_VisitorId_DateTime_TagName] ON [dbo].[VisitorTags]
(
[VisitorId] ASC,
[DateTime] ASC,
[TagName] 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

===================================

USE [HawaiianAirlines_Analytics]
GO

/****** Object:  Index [IX_Custom_TestSetId_Date]    Script Date: 1/19/2016 5:00:51 PM ******/
CREATE NONCLUSTERED INDEX [IX_Custom_TestSetId_Date] ON [dbo].[Pages]
(
[TestSetId] ASC
)
INCLUDE ( [DateTime]) 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

=================================

USE [HawaiianAirlines_Analytics]
GO

/****** Object:  Index [IX_Custom_TestSetId]    Script Date: 1/19/2016 11:03:09 AM ******/
CREATE NONCLUSTERED INDEX [IX_Custom_TestSetId] ON [dbo].[Pages]
(
[TestSetId] ASC
)
INCLUDE ( [PageId],
[VisitId],
[TestValues]) 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

======================================

USE [HawaiianAirlines_Analytics]
GO

/****** Object:  Index [IX_Custom_PageEventDefinitionId]    Script Date: 1/19/2016 11:24:21 AM ******/
CREATE NONCLUSTERED INDEX [IX_Custom_PageEventDefinitionId] ON [dbo].[PageEvents]
(
[PageEventDefinitionId] ASC
)
INCLUDE ( [PageEventId],
[VisitId],
[Data]) 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

=======================================