Each time a statement is sent to a database, the database server must perform the following steps:
It must parse the statement and transform it into an internal form. This process is sometimes called preparing the statement.
It must verify the correctness of all references to database objects by checking, for example, that columns named in a query actually exist.
If the statement involves joins or subqueries, then the query optimizer generates an access plan.
It executes the statement after all these steps have been carried out.
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|