A table-value function normally returns a set of rows ... inline TVFs are inlined and optimized as normal. Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined.