title: Amazon RedShift - How to query OLAP way
body: <p>I'm coping MySQL databases to Red-Shift with the help of an ETL tool called <a href="https://www.matillion.com/" rel="nofollow noreferrer">Matillion</a>, and I'm using the same tool to query the database. Most of the queries I've written are basic <code>select</code> queries with lots of <code>joins</code>, <code>unions</code> and sub-queries. </p>
  
  <p>Since Red-Shift is specialized for analytical processing, I want to transform my basic queries into OLTP queries. </p>
  
  <p>I'll be grateful if someone could point me a direction to learn how to write queries more OLTP way.</p>
  
  <p>Thanks!</p>