Sql Server, Query Optimization.
Server provides various types of partition functions, such as range, list, and hash functions. Partition Scheme — A partition scheme maps the partitions to physical filegroups. It specifies the filegroup where each partition is stored. One partition scheme can be associated with multiple tables.