Anzeige
Erschienen in:
2021 | OriginalPaper | Buchkapitel
6. Long Queries and Full Scans
verfasst von : Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova
Erschienen in: PostgreSQL Query Optimization
Verlag: Apress
Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.
Wählen Sie Textabschnitte aus um mit Künstlicher Intelligenz passenden Patente zu finden. powered by
Markieren Sie Textabschnitte, um KI-gestützt weitere passende Inhalte zu finden. powered by
Abstract
A query is considered long if a significant part of at least one large table is needed to calculate the output. The techniques needed to tune long queries differ from those for short queries. We show how to reduce the size of data being processed during the execution of a long query, how to reduce the naumber of full scans and how to control the choice of join algorithms and other decisions made by the optimizer.