OleDbProviderSettings.IndexAsAccessPath Propiedad
Gets or sets the Boolean property value that specifies whether the OLE DB provider indexes are used to fetch data.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property IndexAsAccessPath As Boolean
Get
Set
'Uso
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)
Valor de la propiedad
Tipo: 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.
Comentarios
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.
Ejemplos
Utilizar servidores vinculados en SMO