Share via

  • Article

Index.Level3Grid Property

Specifies the third level of decomposition for a geometry data type.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public Property Level3Grid As SpatialGeoLevelSize
    Get
    Set
'Usage
Dim instance As Index
Dim value As SpatialGeoLevelSize

value = instance.Level3Grid

instance.Level3Grid = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public SpatialGeoLevelSize Level3Grid { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property SpatialGeoLevelSize Level3Grid {
    SpatialGeoLevelSize get ();
    void set (SpatialGeoLevelSize value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member Level3Grid : SpatialGeoLevelSize with get, set

function get Level3Grid () : SpatialGeoLevelSize
function set Level3Grid (value : SpatialGeoLevelSize)

Remarks

The index-creation process decomposes the space into a four-level grid hierarchy. These levels are referred to as level 1 (the top level), level 2, level 3, and level 4.

Each successive level further decomposes the level above it, so each upper-level cell contains a complete grid at the next level. On a given level, all the grids have the same number of cells along both axes (for example, 4x4 or 8x8), and the cells are all one size.

This property cannot be modified by using the Alter() method. To change the property, the index must be rebuilt or re-created.