How Multi-Statement Table Valued Functions improve in SQL 2017
Multi-Statement Table Valued Functions get actual statistics instead of assuming only 100 rows. It also grants the optimizer to utilize the proper join. Finally, it will procure a proper memory grant.