Rowstore index recommended on table with columnstore index

Question

I was checking today my DPA portal and I found that DPA is recommending 3 nonclustered indexes on my FACT table. My confusion is that all FACT tables in this project have columnstore indexes on them.

Does DPA support columnstore indexes? Is it really saying a rowstore index would be better than a columnstore? The query is selecting a bunch of columns from a FACT table joining with a lot of DIM tables and looking for all the info between 2 dates.

Thanks

mandevil · Accepted Answer

Just to be clear, the index recommendations you are seeing are coming from SQL Server.

Here is a good article on it. Find missing indexes using SQL Servers index related DMVs | Basit's SQL Server Tips

We're just reporting what we find from these DMVs (just like all tools out there currently).

I think your question would be better directed to SQL Server support....

Rowstore index recommended on table with columnstore index

Top Replies