SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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?


No comments.

Leave a Comment

Please register or log in to leave a comment.