3 ms·
Hi George, these are valid points. I can confirm we don't employ result caching in Brytlyt, if we did; 1) all run times would be identical regardless of query 2
by richard_heyns 9y ago
Hi George, these are valid points. I can confirm we don't employ result caching in Brytlyt, if we did;
1) all run times would be identical regardless of query
2) the run times would be an order of magnitude faster
I agree there is quite a bit more to a data warehouse performance than table scan speed. There are queries where scan speed is important and in the retail industry, COUNT DISTINCT is one of them.
I agree the queries in this benchmark is simple, that doesn't mean they're not significant.