/plushcap/analysis/datastax/datastax-running-count-expensive-cassandra

Is Running Count(*) Expensive on Cassandra?

What's this blog post about?

The `count(*)` function in Apache Cassandra returns the number of rows in a table, but it is expensive due to the full table scan required. This can be problematic as Cassandra tables are distributed across multiple nodes. There are alternative methods for counting rows that do not require running the `count(*)` function, such as using secondary indexes or executing queries with specific WHERE clauses. These alternatives can save resources and still provide accurate results. DataStax Academy offers courses to enhance Cassandra skills further.

Company
DataStax

Date published
Jan. 16, 2020

Author(s)
Nikhil Karnik

Word count
223

Hacker News points
None found.

Language
English


By Matt Makai. 2021-2024.