Sample Header Ad - 728x90

Hash, Replication, and Round Robin Distributions - Need more clarification

0 votes
1 answer
284 views
I will give a few examples of the tables we have: Table1 - Most queries are State Code and Year, has about 1000 rows, will grow by 1000 rows a year, used Round Robin Table2 - Most queries are by State Code, Year, Column 1 (String), has about 1000 rows, will grow by 1000 rows a year, used Round Robin Table3 - Most queries are by State Code and Year, has about 100,000 rows, will grow by about 25000 rows a year, used Hash Table4 - Most queries are by Year, has about 100,000 rows, will grow by about 25000 rows a year, plan to use Hash Lookup Table 5 - Most queries are by State Code and Look up Id, has about 10 rows, used Replication Lookup Table 6 - Most queries are by State Code and Look pup Id, has about 500 rows, used Replication Did we use the correct types of distribution? Can someone give a more concrete/better example/clarification of when/why you should use each type of distribution? Microsoft's documentation/guidance wasn't very helpful.
Asked by xmlapi (11 rep)
Dec 20, 2022, 09:26 PM
Last activity: May 11, 2025, 04:06 PM