laptop and a wrench

Bug

There are redundant object ID indexes after registering a feature class as branch versioned in the Microsoft SQL Server enterprise geodatabase.

ArcGIS Pro
Bug ID Number BUG-000162441
SubmittedOctober 27, 2023
Last ModifiedJune 5, 2024
Applies toArcGIS Pro
Version found3.1.3
Operating SystemWindows OS
Operating System VersionN/A
StatusAs Designed

Additional Information

The gdb_ct1 index (objectID, gdb_from_date, gdb_branch_id) and gdb_ct2 index (gdb_branch_id, gdb_from_date, objectID) are different and used explicitly in branch versioned queries. Having multiple indexes on the same column does not indicate a problem or that they are redundant. Different workflows in different parts of the software can use these indexes. There is no workflow or data provided with this bug to demonstrate how the existence of these indexes causes a problem.

Steps to Reproduce

Bug ID: BUG-000162441

Software:

  • ArcGIS Pro

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