Performance between count(*) vs count(column_name)

[divya...@gmail.com]

Hi,

I wanted to understand if there is any performance difference between count(*) and count(column_name) while querying a Pinot Table.

We have 60 dimension columns and each of them has an inverted index.

From my understanding, in a columnar store, count(*) is an expensive operation. But does having the inverted index mitigate the performance issues?

[kishore g]

There is no difference in performance between count(*) and count(column)

--
You received this message because you are subscribed to the Google Groups "Pinot Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pinot_users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pinot_users/d791e800-2bc6-48aa-b598-3d779d6357f3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.