Don't use DISTINCT as a "join-fixer"
I've quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a "join-fixer," and I
Selectcustomeridfromdbo Ordersaso Selectc Customer Innerjoindbo Orderdetailsasod Selectcust Customer Innerjoindbo Productsasp Whereod Order
Source: red-gate.com