Mimer SQL User's Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


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
Mimer SQL User's Manual TOC PREV NEXT INDEX