Fragmentation in consistent hashing

1. Which type of fragmentation is implemented by consistent hashing?
2. Assume that SQL Server uses two threads when processing queries, one thread to parse and build the access plan, and another to run the access plan. Which architecture is being used in this scenario?

Sample Solution