All Products
Search
Document Center

PolarDB:ganos.geometry.mbbox_split_points

Last Updated:Feb 13, 2025

Specifies the number of points in each segment for splitting objects to create the multi-bounding box spatial index.

Data type

Integer

Valid values

2 to 100000. Default value: 100.

Description

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 number of points in each segment exceeds the maximum number of segments defined by this parameter, the number of points in each segment is calculated by using the following formula: Number of points = Total number of points/Maximum number of segments.

Example

Specify the number of points in each segment for splitting objects to create the multi-bounding box spatial index for the current session.

SET ganos.geometry.mbbox_split_points = 150;