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

Index Parameters

· 52CE 我爱测

Learn more about: Index Parameters

Applies to: Windows | Windows Server

Index Parameters

This topic contains parameters that are used for the index.

JET_paramIndexTupleIncrement
132

This parameter specifies the default for the offset increment used to step through the source column value while generating each tuple. For more information, see the JET_TUPLELIMITS structure.

Label Value
Default Value: 1
Type: Integer
Valid Range: 0 - 32767
Scope: Instance
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: No
Affects Resources: No
Availability: Windows Vista and later releases

JET_paramIndexTupleStart
133

This parameter specifies the default for the offset in the source column value at which tuple generation will start. For more information, see the JET_TUPLELIMITS structure.

Label Value
Default Value: 0
Type: Integer
Valid Range: 0 - 32767
Scope: Instance
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: No
Affects Resources: No
Availability: Windows Vista and later releases

JET_paramIndexTuplesLengthMax
111

This parameter specifies the default for the maximum tuple length in a tuple index. For more information, see the JET_TUPLELIMITS structure.

Windows Vista:  Prior to Windows Vista, setting this parameter to zero would set it back to its default value. For Windows Vista, this is no longer supported.

Label Value
Default Value: 10
Type: Integer
Valid Range: Windows 2000, Windows XP and Windows Server 2003:   0, 2-255Windows Vista:  2-255
Scope: Instance
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: No
Affects Resources: No
Availability: Windows XP and later releases

JET_paramIndexTuplesLengthMin
110

This parameter specifies the default for the minimum tuple length in a tuple index. See JET_TUPLELIMITS for more information.

Windows Vista:  Prior to Windows Vista, setting this parameter to zero would set it back to its default value. For Windows Vista, this is no longer supported.

Label Value
Default Value: 3
Type: Integer
Valid Range: Windows 2000, Windows XP and Windows Server 2003:   0, 2-255Windows Vista:  2-255
Scope: Instance
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: No
Affects Resources: No
Availability: Windows XP and later releases

JET_paramIndexTuplesToIndexMax
112

This parameter specifies the default for the maximum length of a source string to break into tuples for a tuple index. See JET_TUPLELIMITS for more information.

Windows Vista:  Prior to Windows Vista, setting this parameter to zero would set it back to its default value. For Windows Vista, this is no longer supported.

Label Value
Default Value: 32767
Type: Integer
Valid Range: Windows 2000, Windows XP and Windows Server 2003:  0 – 32767Windows Vista:  1 – 32767
Scope: Instance
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: No
Affects Resources: No
Availability: Windows XP and later releases

JET_paramUnicodeIndexDefault
72

This parameter controls the default Unicode parameters used by any index over a Unicode key column. The type of this parameter is JET_UNICODEINDEX and is actually passed using a buffer pointer stored in the integer parameter of JetGetSystemParameter and JetSetSystemParameter. The size of the buffer must equal the size of JET_UNICODEINDEX and must be passed to JetGetSystemParameter using the string buffer size parameter. This is clearly inconsistent but that is the behavior of this parameter.

The default value of this parameter contains an LCID for the U.S. English locale and the following LCMapStringWflags: LCMAP_SORTKEY, NORM_IGNORECASE, NORM_IGNOREKANATYPE, and NORM_IGNOREWIDTH.

Windows 2000:  The SORTID in the LCID is ignored. A SORTID of SORT_DEFAULT is always used.

Windows 2000:  The LCMapStringW flags must contain the following flags: LCMAP_SORTKEY, NORM_IGNORECASE, NORM_IGNOREKANATYPE, and NORM_IGNOREWIDTH. In addition, the LCMapStringWflags may contain the following flags: NORM_IGNORENONSPACE.

Note  If your application wishes to store Unicode data, then it is strongly recommended that you do not rely on the default Unicode parameters for your indexes. The use of U.S. English is tantamount to using the invariant locale and the default LCMapStringWflags are known to seriously interfere with some languages. You should always specify your own settings for the Unicode parameters to JetCreateIndex2 using JET_INDEXCREATE.

Label Value
Default Value: Special
Type: JET_UNICODEINDEX* (JET_UNICODEINDEX)
Valid Range: Special
Scope: Instance
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: No
Affects Resources: No
Availability: All

Requirements

Requirement Value
Client Requires Windows Vista, Windows XP, or Windows 2000 Professional.
Server Requires Windows Server 2008, Windows Server 2003, or Windows 2000 Server.
Header Declared in Esent.h.

See Also

JET_INDEXCREATE
JET_TUPLELIMITS
JET_UNICODEINDEX
JetCreateInstance
JetGetSystemParameter
JetInit
JetSetSystemParameter

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)

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

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