laptop and a wrench

Bug

Extensive Markup Language (XML) indexes are not present for enterprise geodatabase tables when creating or enabling an SQL Server database on Microsoft Azure.

ArcGIS Pro
Bug ID Number BUG-000158239
SubmittedMay 11, 2023
Last ModifiedOctober 28, 2024
Applies toArcGIS Pro
Version found2.9.4
Operating SystemWindows Server
Operating System Version2019 64 Bit
StatusNon-Reproducible

Additional Information

For performance reasons, the XML indexes have been removed from all SQL Server enterprise geodatabases starting with ArcGIS Pro 3.3. Upgrading from the ArcGIS Pro 3.1.7 and 3.2.4 patched releases also removes those indexes.

Workaround

Manually add and view the XML indexes to a geodatabase in SQL Server Management Studio (SSMS).

Steps to Reproduce

Bug ID: BUG-000158239

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

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