非聚集索引

• Table has a nonclustered index
  表有非聚集索引。
• Nonclustered indexes on an indexed view are aligned with the indexed view
  索引视图中的非聚集索引与索引视图对。
• Nonclustered index structures
  非聚集索引结构
• Nonclustered indexes only
  仅限非聚集索引。
• The base table structure is not dependent on the structure of a nonclustered index
  基表结构依赖于非聚集索引的结构。
• Points to the top of the nonclustered index b - tree in the specified partition
  列指向指定分区内非聚集索引b树的顶端。
• The maximum number of indexes in the table hint is 250 nonclustered indexes
  表提示中的最大索引数为250个非聚集索引。
• Two nonclustered indexes
  有两个非聚集索引
• This means that all page locks are not allowed on the nonclustered indexes
  这意味着所有页锁均不允许对非聚集索引使用。
• The default storage size does not include nonclustered indexes and indexed views
  默认存储大小不包括非聚集索引和索引视图。