Ultimate access to all questions.
You have an Azure Synapse Analytics dedicated SQL pool containing a large heap fact table with 50 columns and 5 billion rows. Most queries aggregate values from around 100 million rows and return only two columns. These queries are performing very slowly.
What type of index should you add to achieve the fastest query performance?