Indexing in SQL server and DV 2.0


I started testing the automatedv and found that only clustered columnstore indexes are added for all tables. Would you still add additional indexes? E g. Unique non-clustered for hash keys of hubs and links, business keys od hubs, hash key + load date in Sats? Are there available macros to enforce these indexes?


Hi Marcin,
I guess you can use the indexing macros provided by dbt-sqlserver, please check the dbt docs for mssqlserver configs ( sorry, no links allowed here…)

They will create indices with random names, and you can’t provide a target filegroup.
Not perfect, but a great starting point for a custom macro.

I think you have to create them by yourself. All the indexes you mention are needed in a raw vault.