All Products
Search
Document Center

PolarDB:ganos.geometry.mbbox_split_length

Last Updated:Mar 06, 2025

Specifies the minimum length of each segment for splitting objects to create the multi-bounding box spatial index.

Data type

Double

Valid values

0.0001 to 10000000.00. Default value: 200.

Description

  • The unit of length depends on the object type.

    • When the object is of the geometry type, the length of each segment is the accumulation of the linear distances between two adjacent points.

    • When the object is of the geography type, the length of each segment is the accumulation of the ellipsoid distances between two adjacent points.

  • In business scenarios, this parameter must be used together with the ganos.geometry.mbbox_split_max_segments parameter. If the number of segments after splitting based on the minimum length value of each segment exceeds the maximum number of segments defined by this parameter, the length of each segment is calculated by using the following formula: Segment length = Total length/Maximum number of segments.

Example

Specify the minimum length of each segment for the current session when the objects are split by length to create the multi-bounding box spatial index.

SET ganos.geometry.mbbox_split_length = 300.00;