Skip to main content
Question

Clustered columnstore index

  • Jun 10, 2020 11:46 AM UTC
  • 2 replies
  • 3 views

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

    2 replies

    • JTreadwell
    • Community Manager
    • Jun 12, 2020 2:08 AM UTC

    Hi Per, 

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

     

    Add Index, & Select your desired option:

    Mdv5g-5FOnla7jkhoK0nHg.png

     

    Does that help?

    • per.scheffer
    • Author
    • New Participant
    • Jun 17, 2020 8:39 AM UTC

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

    Terms & ConditionsAccessibility statement