Hi @ratbak thanks for response.
Yes about tipology of application i will never never never exceed 1 milion rows, also because i have a retention of 4-5 years, than i can clean up some stuff.
In alternative infact, as you suggest, i was doing some test with:
pk not clustered: Id (sounds good?)
My common scenario is:
Table B has a FK on TableA(Id)
I join this two tables with a query like this:
select * from TableA a
inner join TableB b on a.tenant_id = b.tenant_id and a.id=b.id
where b.tenant_id = 100 and b.year=2020
This index confguration should be ok right?
Last thing: if i have a table that is accessed only by join, it's ok have only pk clustered on Id without the Tenant?
For example, TableC will never be queries alone, but always in join with TableA and TableB, i don't need Tenant right?
Thanks for your time.