Welcome
What is Spectrum Spatial?
Getting Started
Learn about Spectrum Spatial.
Administration
Configure, manage, monitor, troubleshoot, and tune the performance of your system.
Introduction to Security
Manage user roles and security for Spectrum Spatial and Spectrum Spatial Analyst.
Resources and Data
Learn how to work with spatial and routing data using named resources.
Managing Spatial
Manage the Spectrum Spatial repository and Spectrum Spatial Analyst deployments using Spectrum Spatial Manager.
Development
Learn how to incorporate spatial and routing functionality into your solutions.
Stages
Learn about the spatial and routing stages available for dataflows in Spectrum Enterprise Designer.
Services
Learn how to access spatial and routing services from your applications.
Utilities
Take advantage of the productivity tools that Spectrum Spatial has for working with spatial data.
Reference
Information about Spatial Java properties, MapInfo SQL language, and closest arc snapping when calculating routes.

Delegation Rules: ORDER BY

ORDER BY can be delegated to a data source provider if the data provider supports it.
ORDER BY can be delegated only if the entire query can be delegated.
ORDER BY can be delegated only when it contains a column name or an index that points to a column name. Only one column or alias will be delegated. If there is more than one column in the ORDER BY, the left-most column will be delegated.
ORDER BY cannot be delegated if it contains a function or operator.
If the data source provider supports ORDER BY but does not support GROUP BY, the delegated query will return an ORDER BY with the column to be grouped by.
ORDER BY can be delegated regardless of which parts of the WHERE clause are delegated to the data source provider. This applies to non-aggregating queries only.