Creating shard key /CLUSTERED COLUMNSTORE index on persisted columns

Help Query Tuning
1

We are creating a table as below . This table will be involved in multiple tables joins. Is it advisable to create a tables shard key /CLUSTERED COLUMNSTORE index with persisted columns or not?

CREATE TABLE t (a INT ,
b AS a + 1 PERSISTED INT,
c AS a + 1 PERSISTED INT,
d AS c + 1 PERSISTED INT, key (b,d) USING CLUSTERED COLUMNSTORE
,shard key (b,c));

2

That may be reasonable but it very much depends on your application. See: