title: searching on array items on a DynamoDB table
body: <p>I need to understand how one can search attributes of a DynamoDB that is part of an array. </p>
  
  <p>So, in denormalising a table, say a person that has many email addresses. I would create an array into the person table to store email addresses.</p>
  
  <p>Now, as the email address is not part of the sort key, and if I need to perform a search on an email address to find the person record. I need to index the email attribute.</p>
  
  <ol>
  <li>Can I create an index on the email address, which is 1-many relationship with a person record and it's stored as an array as I understand it in DynamoDB.</li>
  <li>Would this secondary index be global or local? Assuming I have billions of person records?
  
  <ol start="3">
  <li>If I could create it as either LSI or GSI, please explain the pros/cons of each.</li>
  </ol></li>
  </ol>
  
  <p>thank you very much!</p>