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));