大网数据广告活动
磁盘与文件系统

Indexing in the Table

· 52CE 我爱测

Learn more about: Indexing in the Table

Applies to: Windows | Windows Server

Indexing in the Table

An index is a set of key columns that define a persistent ordering of records in a table. Records are index entries in the primary index. One primary index and multiple secondary indexes can be defined to create different orders of data in the table.

Although multiple indices can be defined, the records are physically stored in B+ trees in the order specified by the primary index. The primary index is always a clustered index, and must also be unique. The primary index must be declared before the first table update to preserve the index ordering. When no primary index is defined by the application, the data is stored in the order in which records are added to the table. This special index is referred to as a sequential index.

Separate B+ trees are used to order records according to the secondary index. Index entries in the secondary index contain pointers to the data stored according to the primary index. The index entries for records in the primary index must be unique because the secondary index points to the record using the primary key of the record. Secondary indices may or may not have a uniqueness constraint. For more information, see the Database Overview topic.

Source: Microsoft Learn / Windows Win32 documentation by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / Windows Win32 documentation
适用范围
Windows Win32 API · Source date 04/11/2016
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。