query: Is an "on" criteria quicker than a "where"?
positive_passages.docid: 16178
positive_passages.text: SQL JOIN - WHERE clause vs. ON clause
negative_passages.docid: 111455
negative_passages.text: When can we omit the preposition "on" before weekdays
negative_passages.docid: 30653
negative_passages.text: Comma use before where and in which
negative_passages.docid: 108832
negative_passages.text: Is a join optimized to a where clause at runtime?
negative_passages.docid: 141930
negative_passages.text: Implementing a "Both, Either-or, but Not Null" Requirement in a Database
negative_passages.docid: 96377
negative_passages.text: Can "where" ever be used as the subject of a relative/adjective clause?
negative_passages.docid: 104540
negative_passages.text: "In a list" vs. "on a list"
negative_passages.docid: 9687
negative_passages.text: Fastest way to determine if record exists
negative_passages.docid: 79745
negative_passages.text: Dates and times: "on", "in", "at"?
negative_passages.docid: 115725
negative_passages.text: Strategy for dealing with "which is faster?" questions
negative_passages.docid: 68780
negative_passages.text: Limit on the WHERE col IN (...) condition
negative_passages.docid: 17367
negative_passages.text: Fluent and Query Expression — Is there any benefit(s) of one over other?
negative_passages.docid: 38401
negative_passages.text: When should I use  or >()?
negative_passages.docid: 66300
negative_passages.text: is there a shorter way to set up queries when filtering results?
negative_passages.docid: 36454
negative_passages.text: Can you use an alias in the WHERE clause in mysql?
negative_passages.docid: 125819
negative_passages.text: "In time" versus "on time"
negative_passages.docid: 124247
negative_passages.text: C# code confusion of where clause