3 ms·
Really curious of the performance gain we can get from the secondary index, and the cost of it.
by redhouse 2y ago
Really curious of the performance gain we can get from the secondary index, and the cost of it.
- v5c6 2y agoIt’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