Skip to main content

How do I tell Discovery Hub to use a clustered columnstore index for my fact table in Azure Synapse?

Hi Per, 


Right Click on the table > Advanced > Index Settings...
Wz4DuuW4GO6HTpxd42MfPA.png


 


Add Index, & Select your desired option:


Mdv5g-5FOnla7jkhoK0nHg.png


 


Does that help?


Yes, that helps, thanks. I was looking in Table Settings.


Reply