Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Index.Level2Grid Property

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public SpatialGeoLevelSize Level2Grid { get; set; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.SpatialGeoLevelSize
The second level of decomposition for a geometry data type.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.