I was able to publish the view as a map service.
I created the view using the 'create database view' tool
Then, registered the view with the geodatabase with ArcGIS Pro or ArcMap 10.5
I am using this map service in a agol web map to display the latest inspection record from a table, symbolized from a field.
In other words, the view is used to symbolize desired records.
I will not perform further queries on the view.
The only reason I wanted to create attribute index was so that the view would run faster (because I heard that over time, as data grows, views start lagging in performance draw times).
I will read up on the threads you posted, and let you know if I can think of something else regarding your situation.