VERIFIED SOLUTION i

Query result takes longer to return than expected in Spectrum spatial Analyst

Issue

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.

Cause

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.

Resolution

UPDATED: September 27, 2018
This is identified as a bug. It will be resolved with SSA Patch 12.2.3. 
Environment Details