Horton

select_optimize1.sql

application/sql

Download
Filename: select_optimize1.sql
Type: application/sql
Part: 1
Message: Re: Removing unneeded self joins 
SELECT *
FROM users u1
INNER JOIN users u2 
  ON u1.id = u2.some_non_nullable_int
INNER JOIN users u3 
  ON u2.some_non_nullable_int = u3.id;