query: Performance difference of constraint placement in SQL join-on
positive_passages.docid: 16178
positive_passages.text: SQL JOIN - WHERE clause vs. ON clause
negative_passages.docid: 83319
negative_passages.text: Multiple Indexes vs Multi-Column Indexes
negative_passages.docid: 33417
negative_passages.text: Tune a simple inner join query
negative_passages.docid: 105896
negative_passages.text: Finding a Primary Key Constraint on the fly in SQL Server 2005
negative_passages.docid: 150019
negative_passages.text: Differences between "foreign key" and "constraint foreign key"
negative_passages.docid: 121093
negative_passages.text: Join Query effects natural ordering
negative_passages.docid: 20992
negative_passages.text: SQL not engaging parallelism for extremely large query
negative_passages.docid: 82726
negative_passages.text: Foreign Key (references) constraint on PostgreSQL Foreign Data Wrapper?
negative_passages.docid: 106066
negative_passages.text: Integrity constraints in a relational database - should we overlook them?
negative_passages.docid: 135857
negative_passages.text: Condition within JOIN or WHERE
negative_passages.docid: 146592
negative_passages.text: Is there a faster way to get UNION ALL behavior in Postgres?
negative_passages.docid: 135598
negative_passages.text: ResultSet: Retrieving column values by index versus retrieving by label
negative_passages.docid: 15054
negative_passages.text: Does PostgreSQL optimize adding columns with non-NULL DEFAULTs?
negative_passages.docid: 142713
negative_passages.text: Hash join between master/detail tables produces too-low cardinality estimate
negative_passages.docid: 54895
negative_passages.text: Why is the join built-in having no influence on my code?
negative_passages.docid: 24417
negative_passages.text: "INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"
negative_passages.docid: 123923
negative_passages.text: Why is query choosing horrible execution plan?