Well, after expending notable resources with a support request, the result is: #BUG-000137891 On ArcGIS Pro 2.6.3 and above, slowness in display of ‘Properties’ of spatial views is experienced when definition of the query consists of CAST function, CASE function and storage type GEOGRAPHY Which may or may not become available here at some point: https://support.esri.com/en/Search-Results#search?q=BUG-000137891&content-type=Bugs The technical support analyst determined that removing any one of the CAPS elements above made things speed up. So, it feels like there's a slim chance that a temporary workaround might exist which would require the application of Rube Goldberg design principles. Maybe splitting into views on views, although query optimizer might hand the same thing to ArcGIS Pro which might continue slowly. Maybe make a few steps to persist a table that ArcGIS Pro sees? Idk. cheers & back to work, tim
... View more
I set the vale as you suggested and I could see that the fetch_buffer_size has increased from 20 to 100, so looks great. In addition I have performed Alter Index REORGANIZE on the index associated with ObjectID on the feature class to help reduce data fragmentation. From some tests I've run the speed of data copying from SQL to FGDB increased 2x times, so the result looks quite good. Thank you for your help!
... View more