title: Does using WHERE clause with a SELECT statement increase or decrease performance?
body: <p>I am working on C# WPF application that will interact with a database very often and I am concerned about the performance. </p>
  
  <p>I have a question, when we add a WHERE clause to a SELECT statement, does this increase the performance because less records will be retrieved or it makes the performance worse because it will have to go through all the records anyways then additionally execute a filter?</p>