title: How can I make T-SQL perform OPTION (FORCE ORDER) when defining views?
body: <p>My DBA tells me that I should always use <code>OPTION (FORCE ORDER)</code> in my SQL statements when accessing a particular set of views. I understand this is to prevent the server vetoing the order of his joins.</p>
  
  <p>Fair enough - it's worth while keeping the DBA happy and I am happy to comply.</p>
  
  <p>However, I would like to write a couple of views in my own schema, but this isn't supported apparently.</p>
  
  <p>How then, can I achieve the same when writing my views, ie having <code>OPTION (FORCE ORDER)</code> being enforced?</p>
  
  <p>Thanks
  Fred</p>