title: VIEW or MATERIALIZED VIEW?
body: <p>I have two tables: CITY (~50000 rows) and COUNTRY (~220 rows). THere is a task, to provide which city is in which country via VIEW? And if you are able to use materialized view, is it better? 
  I wrote current query:</p>
  
  <pre><code>CREATE VIEW cc as
  SELECT ct.NAME AS "country", c.NAME AS "cty"
  FROM CITY c JOIN COUNTRY ct ON cnt.CODE=c.COUNTRY;
  </code></pre>
  
  <p>It gives me the information I need, but I didn't realize any difference bitween normal view and materialized one. Which is relevant? </p>