recoverSpatialIndexSql function

String recoverSpatialIndexSql(
  1. String table,
  2. String column
)

Builds the SQL for RecoverSpatialIndex, which rebuilds the R*Tree spatial index for a geometry column.

Useful after bulk-importing geometries directly (bypassing triggers) or after restoring from a backup.

Implementation

String recoverSpatialIndexSql(String table, String column) =>
    "SELECT RecoverSpatialIndex('$table', '$column')";