Skip to content

Download full logo Download logomark

English
Japanese
Korean
Chinese
French
Spanish
Portuguese
Arabic

- Products
  ClickHouse CloudThe best way to use ClickHouse.
  Available on AWS, GCP, and Azure.
  Bring Your Own CloudA fully managed ClickHouse service,
  deployed in your own AWS, GCP or Azure account.
  ClickHouse Managed PostgresUnified data stack for transactions
  and analytics.
  Managed ClickStackManaged observability with high-performance
  queries and long-term retention.
  Langfuse CloudLLM observability and evaluations
  for reliable AI applications and agents.
- Open source
  ClickHouseFast open-source OLAP database for
  real-time analytics.
  ClickStackOpen-source observability stack for logs,
  metrics, traces, and session replays.
  Agentic Data StackBuild AI-powered applications
  with ClickHouse.
  chDBIn-process SQL Engine powered by
  ClickHouse, with a Pandas-compatible API
Get started with ClickHouse Cloud for free
We'll get you started on a 30 day trial and $300 credits to spend at your own pace.
Start free cloud trial
- Use cases
  Real-time analytics
  Observability
  Data warehousing
  Machine learning and GenAI
  All use cases ->
- Industries
  Financial services
  Cybersecurity
  Gaming and entertainment
  E-commerce and retail
  Automotive
  Energy
  All industries ->
Docs
- Company resources
  User stories
  Blog
  Events
  News
  Learning and certification
  Partners
  Videos
  Demos
- Comparisons
  Benchmark hub
  CostBench
  BigQuery
  PostgreSQL
  Redshift
  Snowflake
  Elastic Observability
  Splunk
  Datadog
  OpenSearchFor observability
  Databricks
Pricing
Contact us

English
Japanese
Korean
Chinese
French
Spanish
Portuguese
Arabic

Sign in Get Started

image 512x512 22

Fisnik Kastrati

Blog posts by Fisnik Kastrati

blog banner joins

Engineering

The new cost-based join optimizer with reordering support for non-inner joins

Fisnik Kastrati · Oct 28, 2026

- Company
- Blog
- Our story
- Careers
- Contact us
- Events
- News
- Media
- Join our community
- ClickHouse Community
- GitHub
- Slack
- LinkedIn
- X
- Bluesky
- Telegram
- Meetup
- Comparisons
- BigQuery
- PostgreSQL
- Redshift
- Snowflake
- Elastic
- Splunk
- Datadog
- OpenSearch
- Partners
- AWS
- Azure
- Google Cloud

Stay informed on feature releases, product roadmap, support, and cloud offerings!

Star us on Github

© 2026 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.

Trademark Privacy Security Legal Cookie policy