# How Bits Database Optimization proves a query rewrite is faster

DevFeed: [How Bits Database Optimization proves a query rewrite is faster](<https://devfeed.tech/articles/how-bits-database-optimization-proves-a-query-rewrite-is-faster-2278.md>)

Original publisher: [Read original article](<https://www.datadoghq.com/blog/how-bits-database-optimization-proves-a-query-rewrite-is-faster/>)

Author: Alex Weisberger; Nenad Noveljić; Bowen Chen

Published: 2026-08-31T00:00:00Z

Content type: article

Language: en

Sources: [Datadog | The Monitor blog](<https://devfeed.tech/sources/datadog-the-monitor-blog.md>)

Topics: [Optimization](<https://devfeed.tech/topics/optimization.md>), [database monitoring](<https://devfeed.tech/topics/database-monitoring.md>), [Database](<https://devfeed.tech/topics/database.md>), [synthetic-data](<https://devfeed.tech/topics/synthetic-data.md>), [datasets](<https://devfeed.tech/topics/datasets.md>), [cpu](<https://devfeed.tech/topics/cpu.md>), [IO](<https://devfeed.tech/topics/io.md>), [Security](<https://devfeed.tech/topics/security.md>), [Statistics](<https://devfeed.tech/topics/statistics.md>)

Tags: [cpu](<https://devfeed.tech/tags/cpu.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [database-monitoring](<https://devfeed.tech/tags/database-monitoring.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [performance](<https://devfeed.tech/tags/performance.md>), [security](<https://devfeed.tech/tags/security.md>), [software](<https://devfeed.tech/tags/software.md>), [sql](<https://devfeed.tech/tags/sql.md>), [statistics](<https://devfeed.tech/tags/statistics.md>), [synthetic](<https://devfeed.tech/tags/synthetic.md>), [synthetic-data](<https://devfeed.tech/tags/synthetic-data.md>)

## AI overview

The article explains how Bits Database Optimization validates that a proposed query rewrite is faster. It describes controlled benchmarking with simulated production-like datasets, accounting for cache state, CPU and I/O contention, execution time, and database work.

## Source excerpt

Learn how Bits generates synthetic data, measures simulation fidelity, and uses execution time and database work to determine whether an optimization is truly faster.