title: maximum rows per value vs typical rows per value [teradata]
body: <p>I've been reading about data demographics of teradata and came across with this two terms. It is mentioned that this two goes hand in hand to make good index choice, but I can't seem to understand exactly what is the difference between the two values.
  Can anyone explain to me the exact difference between the two. Examples on how the values are derived would be really helpful.
  I'm thinking both values will come from this query:</p>
  
  <pre><code> sel &lt;columnname&gt;, count(*) 
   from &lt;tablename&gt;
  </code></pre>
  
  <p>Here are the definition of the two terms, btw.</p>
  
  <pre><code>    Maximum Rows/Value –No. of rows for the most-often-occurring value in the column.
      Typical Rows/Value –No. of rows for a typical value in the column.
  </code></pre>
  
  <p>Any inputs will be much appreciated.
  Thank you.</p>