VERIFIED SOLUTION i
If the user runs a query on a database table, results take longer to appear in Spectrum Spatial Analyst. The issue is observed for the tables with large data volume and the delay is more than a couple of minutes.
When SSA passes queries to Spectrum Spatial’s Feature-Service, an additional lower() function on the columns of string type gets introduced. When the table size is huge, the query takes longer to execute.
ResolutionUPDATED: September 27, 2018
This is identified as a bug. It will be resolved with SSA Patch 12.2.3.