Contents Index Query normalization Server capabilities

ASA SQL User's Guide
  Accessing Remote Data
    Internal operations

Query preprocessing


Query preprocessing prepares the query for optimization. It may change the representation of a statement so that the SQL statement Adaptive Server Anywhere generates for passing to a remote server will be syntactically different from the original statement.

Preprocessing performs view expansion so that a query can operate on tables referenced by the view. Expressions may be reordered and subqueries may be transformed to improve processing efficiency. For example, some subqueries may be converted into joins.


Contents Index Query normalization Server capabilities