Extremely fast query performance in all scenarios

Running queries against a single table or multiple tables, querying local tables or data stored in data lakes, with StarRocks, experience 3 to 10 times better performance than other popular solutions.

feature_01
icon-001

Fully vectorized execution engine

With a columnar storage engine and fully vectorized opterators, StarRocks makes full use of CPU processing power and SIMD instructions to boost performance.

icon-002

Cost-based optimizer (CBO)

Query planning is just as or even more important than query execution in boosting query performance. StarRocks' CBO seamlessly helps you find the most optimal plan to execute your queries through multi-table join reorder, sub-query rewrite, Join distributed execution selection, and more, giving StarRocks its class-leading query performance, especially with complex multi-table queries.

icon-003

Pipeline execution framework

Engineered for multicore scheduling, the query parallelism in StarRocks can be adaptively adjusted without the need to set parameters, boosting performance in highly concurrent and hybrid workload.

icon-004

Intelligent materialized view

To further boost performance and reduce load, you can perform transformations on your data using StarRocks' materialized view. With pre-computed joins and data aggregations, the query execution time can be further reduced, enabling more demanding scenarios such as highly concurrent analytics and exploratory ad-hoc analysis against a massive amount of data.

Real-time Analytics: Guaranteed data freshness

From streaming data to data capture, StarRocks guarantees the latest data and is ready to provide fresh insight.

feature_02
icon-005

Primary Key table

StarRocks' Primary Key table is specifically engineered to deliver uncompromised query performance when having concurrent real-time data change operations. The primary key index enables data change operations to be resolved at data ingestion, leaving only the latest version of records. Hence, at query, the merge-on-read operation is not required, predicates & index pushdowns can also be used to boost query performance.

icon-006

Intelligent materialized view

The materialized view of StarRocks can be incrementally updated at data ingestion and perform query rewrite at query execution. With guaranteed consistency between the base table and the MV, StarRocks' MV further accelerates real-time analytics.

Analytics with flexibility: Unleash the full potential of your data

A database that adapts to your use cases, StarRocks provides the flexibility to scale your business on demand with ease.

feature_03
icon-008

External Catalog

Use StarRocks as a unified query interface and store your historical data in data lakes while having real-time streaming data ingested into StarRocks.

icon-009

Star or Snowflake schema

StarRocks supports Star and Snowflake schema for extreme performance even on multi-table queries.

icon-010

Standard SQL

ANSI SQL syntax and MySQL protocol support- StarRocks is compatible with a wide range of clients and BI tools.

icon-011

Resource Groups

StarRocks' resource group can efficiently provision resources for multiple tenants within a cluster that has heterogeneous workloads - implements intra-process resource isolation, and protects mission-critical queries while making full use of resources.

Get Started for Free!

Download Now
Moving Light Moving Light Moving Light Moving Light Moving Light Moving Light