Multi-statement TVFs are essentially slowish nested loops.

(Alexander Kuznetsov) Whenever we are using multi-statement TVFs, we are essentially forcing nested loops logic on the database engine. Although multi-statement TVFs are smart enough and do not always execute once per row, when they do so, they may be much slower than nested loops.

Read More - Register for Free Membership