# Introduction to Trino Cost-Based Optimizer

DevFeed: [Introduction to Trino Cost-Based Optimizer](<https://devfeed.tech/articles/introduction-to-trino-cost-based-optimizer-8626.md>)

Original publisher: [Read original article](<https://trino.io/blog/2019/07/04/cbo-introduction.html>)

Author: Piotr Findeisen, Starburst Data

Published: 2019-07-04T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [Statistics](<https://devfeed.tech/topics/statistics.md>), [cpu](<https://devfeed.tech/topics/cpu.md>), [Network](<https://devfeed.tech/topics/network.md>), [Data Science](<https://devfeed.tech/topics/data-science.md>)

Tags: [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [network](<https://devfeed.tech/tags/network.md>), [statistics](<https://devfeed.tech/tags/statistics.md>)

## AI overview

This article introduces Trino's Cost-Based Optimizer (CBO) and explains how query shape, filters, and table statistics influence execution plans. It shows how Trino transforms naive plans and uses CPU time, memory requirements, and network bandwidth to estimate query cost and improve join planning.

## Source excerpt

Last edited 15 June 2022: Update to use the Trino project name. The Cost-Based Optimizer (CBO) in Trino achieves stunning results in industry standard benchmarks (and not only in benchmarks)! The CBO makes decisions based on several factors, including shape of the query, filters and table statistics. I would like to tell you more about what the table statistics are in Trino and what information can be derived from them.