[redhouse]

Really curious of the performance gain we can get from the secondary index, and the cost of it.

[v5c6]

It’s comparable to and depends on selectivity of the query, like any database index. On a 10TB tpc-ds web_sales with 1:150 selectivity, we see an impressive 95% gain.

If the query fetches out most records for e.g, then gains will be lower