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 JetCreateInstance: |
Yes |
Set after JetInit: |
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 JetCreateInstance: |
Yes |
Set after JetInit: |
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-255 Windows Vista: 2-255 |
Scope: |
Instance |
Set After JetCreateInstance: |
Yes |
Set after JetInit: |
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-255 Windows Vista: 2-255 |
Scope: |
Instance |
Set After JetCreateInstance: |
Yes |
Set after JetInit: |
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 – 32767 Windows Vista: 1 – 32767 |
Scope: |
Instance |
Set After JetCreateInstance: |
Yes |
Set after JetInit: |
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 JetCreateInstance: |
Yes |
Set after JetInit: |
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