2 ms·
Building and storing indexes is not free. If you already understand your access patterns and they involve retrieving large quantities of data to be aggregated t
by mulmen 6y ago
Building and storing indexes is not free. If you already understand your access patterns and they involve retrieving large quantities of data to be aggregated the index is less effective than just writing everything down in order and looking where you know the data is to begin with. In a way the storage becomes the index.
Said another way: in analytic workloads the hard part is not finding the data, it is reading the data.