https://community.esri.com/t5/arcgis-pro-questions/large-spatial-dataset-from-msspatial-database-is/m-p/1648502#M98768 <P>I have large table in a MS database. The table alone has 57GB... holding 18 million features.<BR />The table has a primary clustered key and a spatial index based on its 'Shape' attribute.<BR /><BR />The spatial index was generated with the following statement<BR /><BR /></P><LI-CODE lang="sql">USE Contours_MSSpatial CREATE SPATIAL INDEX SIndex_Contours_Shape ON Contours(Shape) USING GEOMETRY_GRID WITH ( BOUNDING_BOX = (xmin = 440000, ymin = 6050000, xmax = 920000, ymax =6403000), GRIDS = (LOW, LOW, MEDIUM, HIGH), CELLS_PER_OBJECT = 32, PAD_INDEX = ON ); GO</LI-CODE><P><BR />The data are in EPSG:25832 and I can get the layer into the map, but there is only a fraction of the data loaded before it stops loading.<BR /><BR />It takes a while, but in QGIS at least the data are loading. This way I was able to confirm that the data to be shown are actually correct. The spatial index might be the culprit but why does ArcGIS Pro stop reading the data in?&nbsp;</P> Mon, 08 Sep 2025 10:41:14 GMT TomGeo 2025-09-08T10:41:14Z https://community.esri.com/t5/arcgis-pro-questions/large-spatial-dataset-from-msspatial-database-is/m-p/1648502#M98768 <P>I have large table in a MS database. The table alone has 57GB... holding 18 million features.<BR />The table has a primary clustered key and a spatial index based on its 'Shape' attribute.<BR /><BR />The spatial index was generated with the following statement<BR /><BR /></P><LI-CODE lang="sql">USE Contours_MSSpatial CREATE SPATIAL INDEX SIndex_Contours_Shape ON Contours(Shape) USING GEOMETRY_GRID WITH ( BOUNDING_BOX = (xmin = 440000, ymin = 6050000, xmax = 920000, ymax =6403000), GRIDS = (LOW, LOW, MEDIUM, HIGH), CELLS_PER_OBJECT = 32, PAD_INDEX = ON ); GO</LI-CODE><P><BR />The data are in EPSG:25832 and I can get the layer into the map, but there is only a fraction of the data loaded before it stops loading.<BR /><BR />It takes a while, but in QGIS at least the data are loading. This way I was able to confirm that the data to be shown are actually correct. The spatial index might be the culprit but why does ArcGIS Pro stop reading the data in?&nbsp;</P> Mon, 08 Sep 2025 10:41:14 GMT https://community.esri.com/t5/arcgis-pro-questions/large-spatial-dataset-from-msspatial-database-is/m-p/1648502#M98768 TomGeo 2025-09-08T10:41:14Z