Multi Tenant entity Tenant_Id not indexed

Multi Tenant entity Tenant_Id not indexed

  

Is there a reason that the TENANT_ID field on our own multi tenant tables (Entities) is not an indexed field by default? We have entities that are set to be multi tenant and we are not exposing the tenant id on them so we don't see that attribute / field in Service Studio and thus cannot add an index on it. Should we expose it and add the index and then unexpose it?


Without the index, when I run an estimated execution plan, the cost is entirely on fields that are not indexed, and one of those fields is the Tenant_Id


(See image below)

Hello Cody,

When making a table multi-tenant OS creates a view for each tenant. Can't see in your example or you using the full table or the view table?

Hope this gives some information which you can use?

Kind regards,
Evert