title: Redshift join with varchar(40) and 2.3 billions rows
body: <p>I am new to Amazon Redshift. Trying to figure out best way to join two tables in redshift.<br>
  I have 1 table with 2.3 billion records and the id column has datatype varchar(40) with sort key and dist key.<br>
  Doing left join with other table having 23 million records on same column id - sort key and dist key.<br>
  The query takes hours to execute. Is there anything I am doing wrong here?<br></p>