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

TempTableGrbit enumeration

· 52CE 我爱测

Learn more about: TempTableGrbit enumeration

Options for temporary table creation.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

Namespace:  Microsoft.Isam.Esent.Interop
Assembly:  Microsoft.Isam.Esent.Interop (in Microsoft.Isam.Esent.Interop.dll)

Syntax

'Declaration
<FlagsAttribute> _
Public Enumeration TempTableGrbit
'Usage
Dim instance As TempTableGrbit
[FlagsAttribute]
public enum TempTableGrbit

Members

<table> <thead> <tr class="header"> <th></th> <th>Member name</th> <th>Description</th> </tr> </thead> <tbody> <tr class="odd"> <td></td> <td>None</td> <td>Default options.</td> </tr> <tr class="even"> <td></td> <td>Indexed</td> <td>This option requests that the temporary table be flexible enough to permit the use of JetSeek to lookup records by index key. If this functionality it not required then it is best to not request it. If this functionality is not requested then the temporary table manager may be able to choose a strategy for managing the temporary table that will result in improved performance.</td> </tr> <tr class="odd"> <td></td> <td>Unique</td> <td>This option requests that records with duplicate index keys be removed from the final set of records in the temporary table. Prior to Windows Server 2003, the database engine always assumed this option to be in effect due to the fact that all clustered indexes must also be a primary key and thus must be unique. As of Windows Server 2003, it is now possible to create a temporary table that does NOT remove duplicates when the <a href="dn351284(v=exchg.10).md">ForwardOnly</a> option is also specified. It is not possible to know which duplicate will win and which duplicates will be discarded in general. However, when the ErrorOnDuplicateInsertion option is requested then the first record with a given index key to be inserted into the temporary table will always win.</td> </tr> <tr class="even"> <td></td> <td>Updatable</td> <td>This option requests that the temporary table be flexible enough to allow records that have previously been inserted to be subsequently changed. If this functionality it not required then it is best to not request it. If this functionality is not requested then the temporary table manager may be able to choose a strategy for managing the temporary table that will result in improved performance.</td> </tr> <tr class="odd"> <td></td> <td>Scrollable</td> <td>This option requests that the temporary table be flexible enough to allow records to be scanned in arbitrary order and direction using <a href="dn292217(v=exchg.10).md">JetMove(JET_SESID, JET_TABLEID, Int32, MoveGrbit)</a>. If this functionality it not required then it is best to not request it. If this functionality is not requested then the temporary table manager may be able to choose a strategy for managing the temporary table that will result in improved performance.</td> </tr> <tr class="even"> <td></td> <td>SortNullsHigh</td> <td>This option requests that NULL key column values sort closer to the end of the index than non-NULL key column values.</td> </tr> <tr class="odd"> <td></td> <td>ForceMaterialization</td> <td>This option forces the temporary table manager to abandon any attempt to choose a clever strategy for managing the temporary table that will result in enhanced performance.</td> </tr> <tr class="even"> <td></td> <td>ErrorOnDuplicateInsertion</td> <td>This option requests that any attempt to insert a record with the same index key as a previously inserted record will immediately fail with <a href="hh564840(v=exchg.10).md">KeyDuplicate</a>. If this option is not requested then a duplicate may be detected immediately and fail or may be silently removed later depending on the strategy chosen by the database engine to implement the temporary table based on the requested functionality. If this functionality it not required then it is best to not request it. If this functionality is not requested then the temporary table manager may be able to choose a strategy for managing the temporary table that will result in improved performance.</td> </tr> </tbody> </table>

See also

Reference

Microsoft.Isam.Esent.Interop namespace

ForwardOnly

IntrinsicLVsOnly

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 07/30/2014
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

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

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