title: Indexing TenantID in Multi Tenant DB
body: <p>I am creating a multi tenant db for an application. I have gone with the TenantID in every table approach and it works very well. I am at the performance tuning stage.</p>
  
  <p>My question is should each TenantID in every table be indexed for optimized searching as every query on the db will filter on this column?</p>
  
  <p>Look forward to any advice.</p>
  
  <p>Thanks</p>