title: Why does this query result in a MERGE JOIN CARTESIAN in Oracle?
body: <p>Here is my query:</p>
  
  <pre><code>select count(*)
  from email_prod_junc j
  inner join trckd_prod t5 on j.trckd_prod_sk = t5.trckd_prod_sk
  inner join prod_brnd b on t5.prod_brnd_sk = b.prod_brnd_sk
  inner join email e on j.email_sk = e.email_sk
  inner join dm_geography_sales_pos_uniq u on (u.emp_sk = e.emp_sk and u.prod_brnd_sk = b.prod_brnd_sk)
  </code></pre>
  
  <p>The explain plan says:</p>
  
  <p>Cartesian Join between DM_GEOGRAPHY_SALES_POS_UNIQ and EMAIL_PROD_JUNC.</p>
  
  <p>I don't understand why because there is a join condition for each table.</p>