Compartir a través de


Interfaz IRelationalIndex

Represents a SQL Server relational index.

Espacio de nombres:  Microsoft.SqlServer.Management.SqlParser.Metadata
Ensamblado:  Microsoft.SqlServer.Management.SqlParser (en Microsoft.SqlServer.Management.SqlParser.dll)

Sintaxis

'Declaración
Public Interface IRelationalIndex _
    Inherits IIndex, IMetadataObject
'Uso
Dim instance As IRelationalIndex
public interface IRelationalIndex : IIndex, 
    IMetadataObject
public interface class IRelationalIndex : IIndex, 
    IMetadataObject
type IRelationalIndex =  
    interface
        interface IIndex
        interface IMetadataObject
    end
public interface IRelationalIndex extends IIndex, IMetadataObject

El tipo IRelationalIndex expone los siguientes miembros.

Propiedades

  Nombre Descripción
Propiedad pública CompactLargeObjects Gets a value that indicates whether to compact the large object (LOB) data in the index.
Propiedad pública DisallowPageLocks Gets a value that indicates whether the index allows page locks.
Propiedad pública DisallowRowLocks Gets a value that indicates whether the index allows row locks.
Propiedad pública FileGroup Gets the filegroup in which the index pages are stored.
Propiedad pública FileStreamFileGroup Gets the filegroup of the index file stream.
Propiedad pública FileStreamPartitionScheme Gets the partition scheme name for the index.
Propiedad pública FillFactor Gets the percentage of an index page to fill when the index is created or re-created.
Propiedad pública FilterDefinition Gets the index filter definition text.
Propiedad pública IgnoreDuplicateKeys Gets a value that indicates whether the index ignores duplicate keys.
Propiedad pública IndexedColumns Gets the collection of columns that are participating in the index.
Propiedad pública IndexKey Gets the index key that is associated with the index.
Propiedad pública IsClustered Gets a value that indicates whether the index is clustered.
Propiedad pública IsDisabled Gets a value that indicates whether the index is disabled.
Propiedad pública IsSystemNamed Gets a value that indicates whether the index was named automatically by the system.
Propiedad pública IsUnique Gets a value that indicates whether the index is unique.
Propiedad pública MaximumDegreeOfParallelism Gets the maximum number of processors that can be used when running a query that uses the index.
Propiedad pública Name Gets the name of the metadata object. (Se hereda de IMetadataObject.)
Propiedad pública NoAutomaticRecomputation Gets a value that indicates whether statistics are regenerated when the index is created.
Propiedad pública OnlineIndexOperation Gets a value that indicates whether the index is kept online during index operations. This allows for access to the data.
Propiedad pública PadIndex Gets a value that indicates whether space is left open on each page of the intermediate levels of the index.
Propiedad pública Parent Gets the ITabular object that is the parent of this object. (Se hereda de IIndex.)
Propiedad pública PartitionScheme Gets the partition scheme that is associated with the index.
Propiedad pública SortInTempdb Gets a value that indicates whether the index is sorted using the tempdb database for intermediate storage of data.

Arriba

Métodos

  Nombre Descripción
Método público Accept< (Of < <' (T> ) > > ) Accepts a visit from the specified IMetadataObjectVisitor<(Of <(<'T>)>)> object. (Se hereda de IMetadataObject.)

Arriba