title: T-SQL QUERY FILTERING RESULTING IN INFINITE EXECUTION
body: <p>Just sharing my experience, and maybe can i get some clarifications/confirmations.</p>
  
  <p>I'am executing a certain script which will return Customer Information.
  This script has at least 5 to 10 joined tables(with pivots-joined tables), and most likely to return at least 100k records.</p>
  
  <p>The thing is, when i tried to add filter on my WHERE clause - "STATUS != 'CLOSED'", my query runs forever.
  When i change it to "STATUS != 'CLOSE'", my query runs at least 2 minutes.</p>
  
  <p>Also, please be informed that "CLOSED" is not existing.</p>
  
  <p>Is this some kind of bug? Or am i missing something?</p>