title: Design Pattern in DynamoDB to query based on dozens of boolean attributes
body: <p>Given a table with 100 columns containing true-false like properties how do I design the table to enable me to query the table for only the subset of data for which a single column is true.</p>
  <p>I know about using sparse indexes, however, this does not scale very well since you are limited by how many indexes you can create. The next thing is to write multiple lines with the same partition key but using different sort keys representing each column.</p>