According to the ESRI documentation, the Rebuild Indexes tool
is used in databases and enterprise, workgroup, and desktop geodatabases to rebuild existing attribute or spatial indexes. In enterprise, workgroup, and desktop geodatabases, indexes can also be rebuilt on states and state_lineage geodatabase system tables and the delta tables of versioned datasets.
It goes on to say that the tool rebuilds the attribute and spatial indexes of base tables, delta tables, and archive tables in versioned and archive-enabled geodatabases, as well as System Tables (if the parameter is checked). However, this and this documentation make it seem like the tool does different things if run as gdb admin vs. data owner.
In my enterprise environment, my database admin does not own data, and as such does not have options to manage the dataset via Catalog in ArcMap.
Does the geodatabase administrator login rebuild indexes for datasets not owned by the login?
EDIT: Similarly, another esri example uses gdb admin to run the tool on system tables as well as a list of datasets (code sample below), which is what is confusing me. I agree with what Vince is saying in the comments, but can someone verify what the tool is capable of doing?
# Execute rebuild indexes and analyze datasets # Note: to use the "SYSTEM" option the user must be an administrator. workspace = "Database Connections/admin.sde" arcpy.RebuildIndexes_management(workspace, "SYSTEM", dataList, "ALL") arcpy.AnalyzeDatasets_management(workspace, "SYSTEM", dataList, "ANALYZE_BASE", "ANALYZE_DELTA", "ANALYZE_ARCHIVE")