CREATE NONCLUSTERED INDEX [ix_IdVeicolo_IdCliente_Disabilitato_Tipo_incl] ON [dbo].[Transazioni]
(
	[IdVeicolo] ASC,
	[IdCliente] ASC,
	[Disabilitato] ASC,
	[Tipo] ASC
)
INCLUDE ( 	[Status],
	[StatusFatturazione]) 

declare @p__linq__0 bigint = 1

SELECT 
    [GroupBy1].[A1] AS [C1]
    FROM ( SELECT 
        COUNT(1) AS [A1]
        FROM [dbo].[Transazioni] AS [Extent1]
        WHERE ([Extent1].[IdCliente] = @p__linq__0) 
		       AND (0 = [Extent1].[Disabilitato]) 
			   AND ([Extent1].[IdVeicolo] IS NULL) 
			   AND ( NOT ( CAST( [Extent1].[Tipo] AS bigint) IN (cast(7 as bigint), cast(15 as bigint), cast(16 as bigint), cast(17 as bigint), cast(18 as bigint), cast(19 as bigint))))
    )  AS [GroupBy1]

create index ix_fltr_IdCliente_incl1
on Transazioni(IdCliente)
include(tipo)
where [IdVeicolo] IS NULL and [Disabilitato] = 0

create index ix_fltr_IdCliente_incl1
on Transazioni(IdCliente)
include(tipo, IdVeicolo)
where [IdVeicolo] IS NULL and [Disabilitato] = 0

create index ix_fltr_IdCliente_incl1
on Transazioni(IdCliente)
include(tipo, IdVeicolo)
where [IdVeicolo] IS NULL and [Disabilitato] = 0

CREATE NONCLUSTERED INDEX [ix_fltr_datainserimento] ON [dbo].[Transazioni]
(
	[DataInserimento] ASC
)
WHERE ([status]<>(12) AND [disabilitato]=(0) AND [IdDispositivo] IS NULL AND [idcliente] IS NOT NULL AND [statusfatturazione]=(14))

ALTER TABLE [dbo].[Transazioni] ADD  CONSTRAINT [PK_Transazioni] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)

create index ix_fltr_IdCliente_incl1
on Transazioni(IdCliente, IdVeicolo)
include(tipo)
where [IdVeicolo] IS NULL and [Disabilitato] = 0
with(online = on)

CREATE NONCLUSTERED INDEX [ix_IdVeicolo_IdCliente_Disabilitato_Tipo_incl] ON [dbo].[Transazioni]
(
	[IdVeicolo] ASC,
	[IdCliente] ASC,
	[Disabilitato] ASC
)
INCLUDE ( 	[Status],
	[StatusFatturazione],
	[Tipo] ) 
	WITH (DROP_EXISTING = ON)