cost-based query optimizer


Also found in: Wikipedia.

cost-based query optimizer

Software that optimizes an SQL query for the fastest processing, based on the size of the database files and other variables.
References in periodicals archive ?
Pivotal Greenplum Database offers up to 100x performance improvements with the addition of Pivotal Query Optimizer, an advanced cost-based query optimizer for big data.
is the new Pivotal Query Optimizer, the most advanced cost-based query optimizer for big data.
Its self-tuning, cost-based query optimizer is designed to provide top performance without expert measurement and tuning.
Oracle7's advanced cost-based query optimizer automatically selects the optimal execution plan for the complex, data-intensive queries typical of warehouse environments.
Its self-tuning, cost-based query optimizer assists in providing top performance without measurement and tuning by expert personnel.