|
|
SQL Optimizer
The SQL optimizer utilizes table statistics to determine the method to be used to execute an SQL statement. This includes determining the order to access tables in and which indices to use, eliminating the need for the programmer to perform the optimization. This is especially important for complex SQL queries, and queries using views. The optimization is performed at run time, meaning that changes in large dynamic databases are automatically catered for.
|
Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|