ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Tips on using a spatial grid index

The following are tips on using the spatial index grid that is used by Oracle and DB2 on tables containing an ST_Geometry column:

  • Symptoms when a grid size is wrong

    If a grid size is determined to be too large or too small when creating a spatial index in Oracle, the following error occurs:

    CREATE INDEX farm_idx on farm(shape)
    INDEXTYPE is SDE.ST_SPATIAL_INDEX
    PARAMETERS ('st_grids=1000,3000,9000 st_srid=31');
    \
    

    CREATE INDEX farm_idx on farm(shape)
    *
    ERROR at line 1:
    ORA-20006: InValid Grid Size
    ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 43
    ORA-06512: at "SDE.ST_POLYGON", line 236

    To identify common issues with Db2 or Informix, see IBM Knowledge Center documentation.

  • Deferring creation of a spatial index after loading data

    Loading or appending data into a spatial table can decrease the total time it takes to complete the load. It also results in less fragmentation of column indexes, which improves query performance. Therefore, it can be useful to defer creating the spatial index until you complete loading your data into the spatial table.

  • Using ST_AsText to display the ST_Geometry contents

    The human-readable well-known text representation is useful when you want to examine the content of individual geometries. Use the ST_AsText function in a SELECT statement to translate the ST_Geometry contents into well-known text for display.

Related topics

  • The spatial grid index

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal