title: Left outer join and OR clause is slow. Is it possible to join after filtering?
body: <p>I have 2 tables like below. (1 million records in each table) When I join the two table and execute a query with OR clause, it is very slow. Is it possible that  join the 2 tables ?</p>
  
  <pre><code>1. tblA
  
  id | name
  ---------------------
  1  | Bob
  2  | carol
  
  2. tblB
  
  id | name
  ---------------------
  1  | Alice
  2  | carol
  </code></pre>
  
  <p>This is very slow. (or timeout error occur)</p>
  
  <pre><code>select * from `tblA` left outer join `tblB` on `tblA`.`name` = `tblB`.`name` where `tblA`.`name` = 'Alice' or `tblB`.`name` = 'Alice'
  </code></pre>
  
  <p>Each query are not slow.</p>
  
  <pre><code>select * from `tblA` left outer join `tblB` on `tblA`.`name` = `tblB`.`name` where `tblA`.`name` = 'Alice'
  select * from `tblA` left outer join `tblB` on `tblA`.`name` = `tblB`.`name` where `tblB`.`name` = 'Alice'
  </code></pre>