title: Row Stores vs Column Stores
body: <p>Assuming that the database is already populated with data, and that each of the following SQL statements is the one and only query that an application will perform, why is it better to use row-wise or column-wise record storage for the following queries?...</p>
  
  <p>1) <code>SELECT * FROM Person</code></p>
  
  <p>2) <code>SELECT * FROM Person WHERE id=5</code></p>
  
  <p>3) <code>SELECT AVG(YEAR(DateOfBirth)) FROM Person</code></p>
  
  <p>4) <code>INSERT INTO Person (ID,DateOfBirth,Name,Surname) VALUES(2e25,’1990-05-01’,’Ute’,’Muller’)</code> </p>
  
  <p>In those examples <code>Person.id</code> is the primary key.</p>
  
  <p>The article <a href="https://www.percona.com/blog/2016/12/14/row-store-and-column-store-databases/" rel="nofollow noreferrer">Row Store and Column Store Databases</a> gives a general discussion on this, but I am specifically concerned about the four queries above.</p>