Home Forums SQL Server 7,2000 T-SQL Creating an view with Option (Force order) RE: Creating an view with Option (Force order)

  • I stumbled across this abandoned post today while attempting to address the same issue, and thought I'd update it with my conclusion: It's simply not possible to specify the "OPTION (FORCE ORDER)" hint in a view definition (or, so that matter, any SELECT statement options), because the option can only ever be specified once per statement/query - it belongs in the final statement that actually uses the view.

    I would love to find an alternative, because guaranteeing that this hint is always specified on queries that use a particularly complex view can be onerous, or even unrealistic, but for now that seems to be the only option.

    http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.