laptop and a wrench

Bug

ArcMap 10.4 performs slowly when displaying a query layer that includes null geometries.

Last Published: August 25, 2017 ArcGIS for Desktop
Bug ID Number BUG-000095527
SubmittedApril 5, 2016
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.4
Operating SystemWindows OS
Operating System Version2012
StatusWill Not Be Addressed

Additional Information

None of the tables on which all these views are based have any useful indexes build. Add the following indexes; CREATE SPATIAL INDEX [EnergyInvestments_spidx] ON [sde].[EnergyInvestments] ( [pointLocation] )USING GEOMETRY_AUTO_GRID WITH (BOUNDING_BOX =(-170.70199941404, -14.278100285562, 171.38100342762, 66.5640293312806), CELLS_PER_OBJECT = 16) CREATE NONCLUSTERED INDEX [ProgramLookup_idx] ON [sde].[ProgramLookup] ( [ProgramName] ASC ) CREATE NONCLUSTERED INDEX [ModifiedProgramName_idx] ON [sde].[EnergyInvestments] ( [ModifiedProgramName] ASC ) CREATE NONCLUSTERED INDEX [EIGeocoding_EnergyInvestmentID_idx] ON [sde].[EIGeocoding] ( [EnergyInvestmentID] ASC ) and the view performance will be substantially improved. See http://support.esri.com/en/technical-article/000014760 for additional information.

Steps to Reproduce

Bug ID: BUG-000095527

Software:

  • ArcGIS for Desktop

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options