laptop and a wrench

Bug

Spatial queries of certain very large layers that include a definition query are performing very poorly. The way in which the queries are prepared make it difficult for SQL Server to choose or create an optimized query plan.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM012751
SubmittedNovember 1, 2007
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found9.3
Version Fixed9.3
StatusFixed

Workaround

Use attribute-first search order for defintion queries.

Steps to Reproduce

Bug ID: NIM012751

Software:

  • No Product Found

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