Skip to main content
Question

Clustered columnstore index

  • June 10, 2020
  • 2 replies
  • 0 views
P

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

    2 replies

    J
    • JTreadwell
    • Community Manager
    • June 12, 2020

    Hi Per, 

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

     

    Add Index, & Select your desired option:

    Mdv5g-5FOnla7jkhoK0nHg.png

     

    Does that help?

    P
    • per.scheffer
    • Author
    • New Participant
    • June 17, 2020

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

    Terms & ConditionsCookie settingsAccessibility statement