I was taught that you need to 'Analyze' each dataset in enterprise databases as much as you can. It was one of those things that I just did, and which I never thought much about. However, I recently looked up the tool I always use, to see what it actually does: ArcGIS Pro Analyze.
Updates database statistics of business tables, feature tables, and delta tables, along with the statistics of those tables' indexes.
Does this really impact any performance in a measurable way?
Is this something that really is needed?
It seems to me that it is something that could be done (and slightly improve database performance), but really does not do a lot.