title: What are the intended uses of a columnar database?
body: <p>I have a question about columnar databases such as Sybase. I understand columnar databases are very fast when your operation is restricted to single coulmns and doesn’t go across columns, i.e no row based filtering?</p>
  <p>But most queries are a combination of both, filter some rows, then aggregate some columns.</p>
  <p>So really, where do columnar databases shine?</p>