How could I optimize the following query when loading
SELECT V.[N°tickets], V.[Code Caisse], V.[Code Site], V.[Prix de vente TTC] ,
V.Quantité , DATEADD(hour, DATEDIFF(hour, 0, [Date Time]), 0) as [Date Time], V.ID, V.DateOfHire,
V.EAN ,V.[Code Article], V.TVA , V.Alimentaire , V.[Code Structure], V.[Prix de Revient] ,
Case when V.[Code Article] in (SELECT [Code Article]
FROM [Promotion ]
where CONVERT(DATE, V.[Date Time]) between
[Date Debut Promo] and [Date Fin Promo])then 1 else 0 end as Promo,
KeyVenteSite,(select top 1 [OC]
from [dbo].[OC ] r
where [Date Time] between r.[DATE DEBUT] and r.[DATE FIN]
)as oc
,(select top 1 t.comp
from [dbo].[Budget ] t
where t.[Code Site]=[Code Site]
and t.[Code Rayon] =substring([Code Structure],1,4)
and t.[Date Time]=convert(date,[Date Time])
)
as[Comp]
FROM dbo.[Vente ] V
Where (V.[Code Article] is not null) and (V.[Code Structure] is not null) and (V.[Prix de Revient] is not null)
It took hours .
