BOOK-CHAPTER

Configuring the Query Optimizer

Abstract

The query optimizer is directly responsible for the performance of SQL statements. For this reason, it makes sense to take some time to configure it correctly. In fact, without an optimal configuration, the query optimizer may generate inefficient execution plans that lead to poor performance.

Keywords:
Query optimization Computer science SQL Sargable Query by Example Query expansion Query plan Query language Database Web search query Information retrieval Search engine

Metrics

0
Cited By
0.00
FWCI (Field Weighted Citation Impact)
0
Refs
0.09
Citation Normalized Percentile
Is in top 1%
Is in top 10%

Topics

Advanced Database Systems and Queries
Physical Sciences →  Computer Science →  Computer Networks and Communications

Related Documents

BOOK-CHAPTER

Configuring the Query Optimizer

Apress eBooks Year: 2008 Pages: 169-193
BOOK-CHAPTER

Configuring the Optimizer

Sam R. AlapatiDarl KuhnBill Padfield

Apress eBooks Year: 2013 Pages: 457-500
BOOK-CHAPTER

Configuring the Optimizer

Sam R. AlapatiDarl KuhnBill Padfield

Apress eBooks Year: 2011 Pages: 447-490
BOOK-CHAPTER

Configuring Query Store

Tracy BoggianoGrant Fritchey

Apress eBooks Year: 2019 Pages: 47-70
BOOK-CHAPTER

Configuring Database Query Languages

Richard Cooper

Workshops in computing Year: 1995 Pages: 3-21
© 2026 ScienceGate Book Chapters — All rights reserved.