Blog Post

Inline TVFs can't use FORCE ORDER hint but Multi-Statement TVFs can...?

,

Doing some work with converting Multi-Statement TVFs to Inline TVFs and I'm finding that the Inline TVFs cannot use the OPTION FORCE ORDER hint. Multi-Statement TVFs can use it just fine. Does anyone have any more info or experience on why this is the case?

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating