4 ms·
> On the other hand, analytics queries touching a high proportion of rows with joins on equality conditions (ie. hash joinable) isn't going to go any faster wit
by valenterry 3y ago
> On the other hand, analytics queries touching a high proportion of rows with joins on equality conditions (ie. hash joinable) isn't going to go any faster with an index.
That's when you bring a BRIN to the table. :-)
- nojvek 3y agoOr change the layout entirely to clustered columnstore from row store. All databases are datastructures on disk and memory optimized for specific access and write patterns.