10037: Label class value has an SQL query that is not optimizable

Your map layer has a label class with a SQL query that cannot be optimized by the drawing engine. The optimized map service can reduce the number of queries sent to the database in most circumstances, but the SQL query used by this label class cannot take advantage of this optimization.

Solution

Check the drawing performance of your map service in the Preview window. See Publishing optimized map services for more information.

• If no changes are needed, you can accept the display performance as is.
• Alternatively, if you want to improve performance, you should remove any vendor-specific SQL syntax from your query. This allows the drawing engine to optimize the number of queries to the database.

More information

Optimized map services can reduce the number of queries sent to the database if the SQL queries used by labeling are simple. Vendor-specific SQL logic cannot be optimized by the drawing engine.