title: How do I efficiently search a potentially large database?
body: <p>This is more of a discussion. </p>
  
  <p>We have a system which is multitenanted and will have tables that can have millions of rows. Our UI allows users to perform searches against these tables with many different search criterias -- so they can have any combination of these criteria. </p>
  
  <p>It is not practical to index all these search columns in the database or to load the full tables in memory and then filter. </p>
  
  <p><strong>Can anybody point me in the correct direction for patterns/designs that tackles this issue?</strong></p>