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?