Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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?

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.