PROBLEM

Performance of SQL Server views degrades after upgrading to ArcGIS 10.4

Last Published: April 25, 2020

Description

After upgrading to ArcGIS for Desktop 10.4 or later, accessing views that join two or more tables is slower than at earlier releases.

Cause

With ArcGIS for Desktop versionĀ 10.4, there were substantial changes to the transaction model used by ArcGIS with SQL Server. This change included an update to the way data is fetched from the database to the client application. At version 10.3.1 and earlier releases, the entire query result set was pushed to the client in one operation. At version 10.4, data is fetched using a different database API call. In the case of views where multiple tables are joined, each fetch operation performs a full table scan if there is no index present on the join column. Multiple fetches incur multiple full-table scans.

Solution or Workaround

EnsureĀ that the columns used in the joins are correctly indexed. While it is always beneficial to ensure that valid indexes are in place when joining tables, it is much more important to do this at version 10.4 than at earlier releases.

Article ID: 000014760

Software:
  • ArcMap
  • ArcGIS Pro 1 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options