预计算分区

• If precomputed partitions are not used , the subscriber receives both rows , because the table has a case - insensitive collation
  如果未使用预计算分区，订阅服务器会收到这两行，因为该表具有不区分大小写的排序规则。
• There are some restrictions on filters when using precomputed partitions , but if these are met , performance can be significantly increased
  使用预计算分区时对筛选器有些限制，但如果满足了这些限制，则可以显著提高性能。
• This stored procedure returns information about the supplied filter , including whether or not the filter qualifies for use with precomputed partitions
  此存储过程返回所提供的筛选器的相关信息，包括筛选器是否适合用于预计算分区。
• If some articles meet these requirements and some do not , consider creating two publications , with one enabled for precomputed partitions
  如果有些项目满足这些要求而有些不满足，请考虑创建两个发布，为其中一个发布启用预计算分区。
• To use precomputed partitions precomputed partitions are enabled by default on all new and existing publications that adhere to the guidelines described above
  默认情况下，在遵循上述指导原则的所有新发布和现有发布上均启用了预计算分区。
• In particular , the functions used to generate a filtered data partition for a publication , and whether the publication qualifies for using precomputed partitions
  另外，无论发布是否有资格使用预计算分区，这些函数都可用于为其生成筛选数据分区。
• When precomputed partitions are used , the collation of the database is always used when making comparisons , rather than the collation of the table or column
  如果使用了预计算分区，进行比较时始终使用数据库的排序规则，而不使用表或列的排序规则。
• This stored procedure also returns information about the supplied join filter , including whether or not it can be used with precomputed partitions for the given table
  此存储过程还返回提供的联接筛选器的信息，其中包括联接筛选器是否可用于给定表的预计算分区。
• The use of precomputed partitions is a new performance optimization for merge publications that use parameterized filters referred to as " dynamic filters " in previous versions
  预计算分区的使用是对使用参数化筛选（在早期版本中称为“动态筛选器” ）的合并发布的新的性能优化。
• If the following requirements are met , new merge publications are , by default , created with precomputed partitions enabled , and existing publications are automatically upgraded to use the feature
  如果满足下列要求，默认情况下创建新的合并复制时将启用预计算分区，而现有的发布将自动升级以使用此功能。