question

SunilP-5929 avatar image
0 Votes"
SunilP-5929 asked SunilP-5929 answered

Need to know about Azure Synapse "Multiple Database Distribution"

Is there any concept like "Multiple Database Distribution" in Synapse. I know about table distribution like Hash, Round Robin.

I have dedicated SQL pool with some huge tables size is around 1TB running under DWU500C. Is it possible to share this table again with multiple Database so that I can get good select query performance.

About Data: Table contains hourly data from different IOT devices, growing like anything. All in single Table, Table distribution is Hash, created Non-clustered index, and Statistics. Is there any best way to improve the performance?

azure-synapse-analytics
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

What do you mean by "Multiple Database Distribution"? That's not a term I've ever heard before.

0 Votes 0 ·

@sunilp-5929 Can you please provide more clarity to your ask.

Thanks
Saurabh

0 Votes 0 ·

@sunilp-5929 Please help providing more context to the ask so that we can help you.

Thanks
Saurabh

0 Votes 0 ·

1 Answer

SunilP-5929 avatar image
0 Votes"
SunilP-5929 answered

I got clarification for this question, Please ignore this question.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.