cost-based query optimizer

(redirected from 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 ?
NextGig plans to unveil the query optimizer later this year followed by subsequent products in database replication and overall solution enhancement.
Despite its small footprint, SQL Anywhere can create full SQL applications with its referential integrity, transaction processing, stored procedures, triggers, self-tuning query optimizer, row-level locking and full on-line back-up and recovery.
NextGig plans to unveil the query optimizer later in 2002 followed by subsequent products in database replication and overall solution enhancement.
NextGig plans to unveil the query optimizer in the first half of 2002 followed by subsequent products in database replication and overall solution enhancement.
For DSS applications, a more powerful query optimizer gives Oracle data warehousing applications high performance formerly only possible with specialized decision support databases.
The Attunity Connect Application Engine augments Attunity Connect's production-proven Data Engine, which features Attunity's unique distributed Query Optimizer and Processor.
Oracle7's advanced cost-based query optimizer automatically selects the optimal execution plan for the complex, data-intensive queries typical of warehouse environments.
Features such as Dynamic Row Level Locking and the new Query Optimizer provide SAP customers with enhanced ability to deploy highly scalable R/3 solutions with increased data volumes and thousands of users.
to immediately accessible from almost all popularoptimized for the powerful jBASE data architecture, that utilizes ISG's unique Query Processor, Query Optimizer and Data Access Service layers to achieve high performanceNavigator software will be shipped with all new copies of jBASE Enterprise Version within 3 months and will be offered to the installed base of over 25,000 users.
NCR's technology leadership extends across the entire spectrum of data warehousing with 25 patents and nearly two dozen additional patents pending in the areas of interconnect technology, system management, query optimizer technology, and data warehouse infrastructure and tools.
The ISG Navigator option (ISG Navigator integrated with NonStop SQL/MX) provides all of ISG Navigator's features, including a query optimizer and processor for fast results.
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.