通过

  • 项目

IndexAsAccessPath 属性

Gets or sets the Boolean property value that specifies whether the OLE DB provider indexes are used to fetch data.

命名空间：  Microsoft.SqlServer.Management.Smo
程序集：  Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property IndexAsAccessPath As Boolean
    Get
    Set
用法
Dim instance As OleDbProviderSettings
Dim value As Boolean

value = instance.IndexAsAccessPath

instance.IndexAsAccessPath = value

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool IndexAsAccessPath { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool IndexAsAccessPath {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member IndexAsAccessPath : bool with get, set

function get IndexAsAccessPath () : boolean
function set IndexAsAccessPath (value : boolean)

属性值

类型：System. . :: . .Boolean
A Boolean value that specifies whether the OLE DB provider indexes are used to fetch data.
If True, the OLE DB provider indexes are used to fetch data.
If False (default), the SQL Server indexes are used to fetch data.

注释

If nonzero, SQL Server attempts to use indexes of the provider to fetch data. By default, indexes are used only for metadata and are never opened.