the below query takes too Long for me. doy ou have any ideas how to make it faster?
select * from
(select (200/[traveltimeLkw])*3.6 as v_lkw, [entrytime] ,[vLkwCommon] FROM [VRZ1010].[vdp_archiv_stv].[dbo].[STV_SVL_Archiv_20175] where
[roadcode]='A23_1' and [from2dk]>=9000 and [to2dk]<=10000 ) A inner join
(select * from [vdp_evis_db].[dbo].[DayCategory]) B on B.[day]= CONVERT(date,A.[entrytime]) and B.[weekday]=1
DayCategory hast the following columns : day, weekday, weekdayname, daycat
and the other query has the following columns: v_lkw, vlkwcommon and entrytime