SET QUOTED_IDENTIFIER ON
go
SET ARITHABORT ON
go
SET CONCAT_NULL_YIELDS_NULL ON
go
SET ANSI_NULLS ON
go
SET ANSI_PADDING ON
go
SET ANSI_WARNINGS ON
go
SET NUMERIC_ROUNDABORT OFF
go
CREATE VIEW [dbo].[mv_1_6497] WITH SCHEMABINDING
AS
SELECT [dbo].[attachment].[case_id] as _col_1, [dbo].[attachment].[bPurged] as _col_2, count_big(*) as _col_3 FROM [dbo].[attachment] GROUP BY [dbo].[attachment].[case_id], [dbo].[attachment].[bPurged]
go
SET ARITHABORT ON
SET CONCAT_NULL_YIELDS_NULL ON
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET NUMERIC_ROUNDABORT OFF
go
CREATE UNIQUE CLUSTERED INDEX [IXmv_1_6497_c_31_308208894__K2_K1] ON [dbo].[mv_1_6497]
(
[_col_2] ASC,
[_col_1] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go
CREATE NONCLUSTERED COLUMNSTORE INDEX
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.