On a particular table I’m reviewing, I don’t see any auto-generated indexes listed under the Indexes tab unless I manually click the “Refresh auto-generated indexes” link in the “Auto-generated Indexes” section.
Does this behavior mean that all auto-generated indexes (except the nwID) were disabled or does it mean that the table was created before the auto-generated indexes feature was implemented?
Curious if anyone else has encountered this or can confirm how it’s expected to behave.
The auto-generated (AG) indexes are created (as enabled) during every table refresh for table lookups and list lookups, so they will exist in the database regardless of whether a user has opted to “Refresh auto-generated indexes.” That action just displays each index for the user and will persist which indexes, if any, have been disabled.
When an AG index is marked as Disabled in that list and a table refresh occurs, that index will not be created in the database.
We have entered in an idea to always display these auto-generated indexes so end users don’t have to press the refresh button to see them.