Export (0) Print
Expand All
Expand Minimize

Index Properties

The Index type exposes the following members.

  Name Description
Public property BoundingBoxXMax Specifies the x-coordinate of the upper right corner of a bounding box.
Public property BoundingBoxXMin Specifies the x-coordinate of the lower-left corner of a bounding box.
Public property BoundingBoxYMax Specifies the y-coordinate of upper-right corner of a bounding box.
Public property BoundingBoxYMin Specifies the y-coordinate of the lower-left corner of a bounding box.
Public property BucketCount Gets or sets the value of the bucket count for a hash index.
Public property CellsPerObject Defines the maximum number of cells that tessellation can count per object.
Public property CompactLargeObjects Gets or sets the Boolean property value that specifies whether to compact the large object (LOB) data in the index.
Public property DisallowPageLocks Gets or sets the Boolean property value that specifies whether the index allows page locks.
Public property DisallowRowLocks Gets or sets the Boolean property value that specifies whether the index allows row locks.
Public property DistributionColumns Retrieves the collection of distribution columns used by the distribution policy on this index.
Public property DistributionPolicy Returns the distribution policy that is currently used to distribute the rows of the current Index across the bricks.
Public property Events Gets the index events supported by the Index object.
Public property ExtendedProperties Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property defined on the Index object.
Public property FileGroup Gets or sets the filegroup where the index pages are stored.
Public property FileStreamFileGroup Gets or Sets the file group name for the index.
Public property FileStreamPartitionScheme Gets or Sets the partition scheme name for the index.
Public property FillFactor Gets or sets the percentage of an index page to fill when the index is created or re-created.
Public property FilterDefinition Gets or sets the String value that contains the definition for the filter.
Public property HasCompressedPartitions Gets or sets the Boolean property value that specifies whether the index has compressed partitions.
Public property HasFilter Gets the Boolean property value that specifies whether the index has a filter defined for a range of index values.
Public property ID Gets the index ID value that uniquely identifies the index within the database.
Public property IgnoreDuplicateKeys Gets or sets the Boolean property value that specifies whether the index ignores duplicate keys.
Public property IndexedColumns Gets a collection of IndexedColumn objects that represent all the columns participating in the index.
Public property IndexedXmlPathName Gets or sets the name of the indexed XML path.
Public property IndexedXmlPathNamespaces Gets the collection of indexed XML path namespace.
Public property IndexedXmlPaths Gets or sets the collection of indexed XML paths.
Public property IndexKeyType Gets or sets the index key type.
Public property IndexType Gets or sets the type of index.
Public property IsClustered Gets or sets the Boolean property value that specifies whether the index is clustered.
Public property IsDisabled Gets or sets the Boolean property value that specifies whether the index is disabled.
Public property IsFileTableDefined Gets or sets whether the file table is defined.
Public property IsFullTextKey Gets the Boolean value that specifies whether the index is enabled for row identification in Microsoft Search.
Public property IsIndexOnComputed Gets the Boolean property value that specifies whether the index is based on a computed column.
Public property IsIndexOnTable Gets the Boolean property value that specifies whether the index is defined for a table or a view.
Public property IsMemoryOptimized Gets or sets the Boolean property value that specifies whether the index is memory optimized.
Public property IsPartitioned Gets the Boolean property value that specifies whether the index is stored in a partitioned scheme.
Public property IsSpatialIndex Gets a value that indicates whether an index is a spatial index.
Public property IsSystemNamed Gets the Boolean property value that specifies whether the index was named automatically by the system.
Public property IsSystemObject Gets the Boolean property value that specifies whether the index is a system object.
Public property IsUnique Gets or sets the Boolean property value that specifies whether the index is unique or not.
Public property IsXmlIndex Gets or sets the Boolean property value that specifies whether the index is an XML index.
Public property Level1Grid Gets or sets the first level of decomposition for a geometry data type.
Public property Level2Grid Specifies the second level of decomposition for a geometry data type.
Public property Level3Grid Specifies the third level of decomposition for a geometry data type.
Public property Level4Grid Gets or sets the fourth level of decomposition for a geometry data type.
Public property LowPriorityAbortAfterWait Specifies the action that will be taken after the Low Priority expires during an online index build operation on this index.
Public property LowPriorityMaxDuration Specifies the amount of time (in minutes) to wait with Low Priority for acquiring the locks required for the online index build operations on this Index.
Public property MaximumDegreeOfParallelism Gets or sets the maximum number of processors that can be used when running a query that uses the index.
Public property Name Gets or sets the name of the index. (Overrides NamedSmoObject.Name.)
Public property NoAutomaticRecomputation Gets or sets the Boolean property value that specifies whether statistics are regenerated when an index is created.
Public property OnlineIndexOperation Gets or sets the Boolean property value that specifies whether the index will be kept online during index operations thus allowing access to the data.
Public property PadIndex Gets or sets the Boolean property value that specifies whether space is left open on each page of the intermediate levels of the index.
Public property Parent Gets or sets the SqlSmoObject object that is the parent of the Index object.
Public property ParentXmlIndex Gets or sets the parent of an XML index.
Public property PartitionScheme Gets or sets the partition scheme associated with the index.
Public property PartitionSchemeParameters Represents a collection of PartitionSchemeParameter objects. Each PartitionSchemeParameter object represents a parameter in the partition scheme associated with the index.
Public property PhysicalPartitions Gets a collection of PhysicalPartition objects that represent all the physical partitions on which the index is stored.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property SecondaryXmlIndexType Gets or sets the secondary XML index type.
Public property SortInTempdb Gets or sets the Boolean property value that specifies whether the index is sorted using the tempdb database for intermediate storage of data.
Public property SpaceUsed Gets or sets the disk space used to store the index data in kilobytes.
Public property SpatialIndexType Gets or sets the Spatial Index Type for a column.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top

  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Gets a Boolean value that indicates whether the object supports design mode.
Top

Community Additions

ADD
Show:
© 2014 Microsoft