Test Perfs

-- Count V1
SELECT COUNT(*)
FROM [Contrats] AS [c]
LEFT JOIN [Secteurs] AS [s] ON [c].[SecteurId] = [s].[Id]
LEFT JOIN [Sites] AS [s0] ON [s].[SiteId] = [s0].[Id]
LEFT JOIN [Regions] AS [r] ON [s0].[RegionId] = [r].[Id]
INNER JOIN [Dossiers] AS [d] ON [c].[DossierId] = [d].[Id]
WHERE EXISTS (
SELECT DISTINCT 1
FROM [ProfilEntreprises] AS [p]
WHERE [p].[ProfilId] IN (N'0924fd54-295a-413f-96bd-e782efc89ba6', N'0f960d1b-1e25-4a0c-a34f-f56a71423c30', N'5fa7aec4-9477-4409-853c-fdde69ed6ce4', N'd622ade5-c7f2-437f-9c32-ddeb9c6a67eb', N'ebaac07a-29e2-452e-95ab-66b8042dc8fc') AND (([p].[EntrepriseId] = [r].[EntrepriseId]) OR (([p].[EntrepriseId] IS NULL) AND ([r].[EntrepriseId] IS NULL)))) AND ((((EXISTS (
SELECT 1
FROM [ProfilEntreprises] AS [p0]
WHERE ([p0].[ProfilId] IN (N'0924fd54-295a-413f-96bd-e782efc89ba6', N'0f960d1b-1e25-4a0c-a34f-f56a71423c30', N'5fa7aec4-9477-4409-853c-fdde69ed6ce4', N'd622ade5-c7f2-437f-9c32-ddeb9c6a67eb', N'ebaac07a-29e2-452e-95ab-66b8042dc8fc') AND (((([p0].[RegionId] IS NULL) AND ([p0].[SiteId] IS NULL)) AND ([p0].[BrancheId] IS NULL)) AND ([p0].[SecteurId] IS NULL))) AND (([r].[EntrepriseId] = [p0].[EntrepriseId]) OR (([r].[EntrepriseId] IS NULL) AND ([p0].[EntrepriseId] IS NULL)))) OR EXISTS (
SELECT 1
FROM [ProfilEntreprises] AS [p1]
WHERE ([p1].[ProfilId] IN (N'0924fd54-295a-413f-96bd-e782efc89ba6', N'0f960d1b-1e25-4a0c-a34f-f56a71423c30', N'5fa7aec4-9477-4409-853c-fdde69ed6ce4', N'd622ade5-c7f2-437f-9c32-ddeb9c6a67eb', N'ebaac07a-29e2-452e-95ab-66b8042dc8fc') AND ((([p1].[SiteId] IS NULL) AND ([p1].[BrancheId] IS NULL)) AND ([p1].[SecteurId] IS NULL))) AND (([s0].[RegionId] = [p1].[RegionId]) OR (([s0].[RegionId] IS NULL) AND ([p1].[RegionId] IS NULL))))) OR EXISTS (
SELECT 1
FROM [ProfilEntreprises] AS [p2]
WHERE ([p2].[ProfilId] IN (N'0924fd54-295a-413f-96bd-e782efc89ba6', N'0f960d1b-1e25-4a0c-a34f-f56a71423c30', N'5fa7aec4-9477-4409-853c-fdde69ed6ce4', N'd622ade5-c7f2-437f-9c32-ddeb9c6a67eb', N'ebaac07a-29e2-452e-95ab-66b8042dc8fc') AND ((([p2].[SiteId] IS NULL) AND ([p2].[RegionId] IS NULL)) AND ([p2].[SecteurId] IS NULL))) AND (([s0].[BrancheId] IS NOT NULL) AND ([s0].[BrancheId] = [p2].[BrancheId])))) OR EXISTS (
SELECT 1
FROM [ProfilEntreprises] AS [p3]
WHERE ([p3].[ProfilId] IN (N'0924fd54-295a-413f-96bd-e782efc89ba6', N'0f960d1b-1e25-4a0c-a34f-f56a71423c30', N'5fa7aec4-9477-4409-853c-fdde69ed6ce4', N'd622ade5-c7f2-437f-9c32-ddeb9c6a67eb', N'ebaac07a-29e2-452e-95ab-66b8042dc8fc') AND ([p3].[SecteurId] IS NULL)) AND (([s].[SiteId] = [p3].[SiteId]) OR (([s].[SiteId] IS NULL) AND ([p3].[SiteId] IS NULL))))) OR EXISTS (
SELECT 1
FROM [ProfilEntreprises] AS [p4]
WHERE [p4].[ProfilId] IN (N'0924fd54-295a-413f-96bd-e782efc89ba6', N'0f960d1b-1e25-4a0c-a34f-f56a71423c30', N'5fa7aec4-9477-4409-853c-fdde69ed6ce4', N'd622ade5-c7f2-437f-9c32-ddeb9c6a67eb', N'ebaac07a-29e2-452e-95ab-66b8042dc8fc') AND (([c].[SecteurId] = [p4].[SecteurId]) OR (([c].[SecteurId] IS NULL) AND ([p4].[SecteurId] IS NULL)))))
GO
-- Count V2
SELECT COUNT(*)
FROM [Contrats] AS [c]
LEFT JOIN [Secteurs] AS [s] ON [c].[SecteurId] = [s].[Id]
LEFT JOIN [Sites] AS [s0] ON [s].[SiteId] = [s0].[Id]
LEFT JOIN [Regions] AS [r] ON [s0].[RegionId] = [r].[Id]
INNER JOIN [Dossiers] AS [d] ON [c].[DossierId] = [d].[Id]
INNER JOIN ProfilEntreprises P ON
    P.EntrepriseId = R.EntrepriseId AND
        (P.RegionId IS NULL
        OR (P.RegionId = s0.RegionId AND
            (P.SiteId IS NULL
            OR (P.SiteId = s.SiteId AND
                (P.SecteurId IS NULL OR P.SecteurId = s.Id)
            )
        )
        OR (P.BrancheId = s0.BrancheId AND
            (P.SiteId IS NULL
            OR (P.SiteId = s.SiteId AND
                (P.SecteurId IS NULL OR P.SecteurId = s.Id)
            )
        )
WHERE
    P.ProfilId IN (N'0924fd54-295a-413f-96bd-e782efc89ba6', N'0f960d1b-1e25-4a0c-a34f-f56a71423c30', N'5fa7aec4-9477-4409-853c-fdde69ed6ce4', N'd622ade5-c7f2-437f-9c32-ddeb9c6a67eb', N'ebaac07a-29e2-452e-95ab-66b8042dc8fc')