Why does the location of a join change performance?
55290
join syntax / style performance consideration
73561
Oracle Joins - Comparison between conventional syntax VS ANSI Syntax
120518
Explanation of self-joins
34096
LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
16107
JOIN queries vs multiple queries
18781
SQL count(*) performance
33435
Database: Best performance way to query geo location data?
51714
One-to-many spatial join with results in one row
54895
Why is the join built-in having no influence on my code?
10221
Sql insert query performance
100461
When or why would you use a right outer join instead of left?
1408
SQL JOIN vs IN performance?
123923
Why is query choosing horrible execution plan?
126514
Does anyone use Right Outer Joins?
103235
When a previously-fast SQL query starts running slow, where do I look to find the source of the issue?
88087
Why does this say there is no join predicate?
135857
Condition within JOIN or WHERE