Attribute Table — Indicate fields that have a unique index

Bud — Wed, 22 Nov 2023 15:58:08 GMT

In the attribute table, fields that are used in a database index are indicated with an asterisk:

There are multiple indexes on that table:

Unique index on UNIT_RATE_ID
Composite index (unique) on:
- ASSET_CLASS
- STRATEGY
- ACTIVITY
- TYPE
- UNIT_RATE_TYPE
- UNIT_RATE_YEAR
Non-unique indexes on other fields to improve query and join performance.

It's great that the indexed fields are shown with an asterisk. It would be even better if it showed if the field is used in a unique index or not. Knowing if a field is constrained by a unique index helps when editing data.

For example, those fields could be marked by a double asterisk. Or something like that.

Additionally, the hover text could also indicate if the field is used in a unique index:

idea Attribute Table — Indicate fields that have a unique index in ArcGIS Pro Ideas

Attribute Table — Indicate fields that have a unique index