At Creating the Array Domain - TileDB Docs, the following advice is provided.
“Remember to give priority to more selective dimensions, in order to maximize the pruning power during slicing.”
I was wondering if someone could give an example of how to interpret this statement. When one says “selective dimension”, is the idea:
- similar to for e.g. some databases asking the left table of a join to be smaller than the right table. That way, less data has to be handled
- to have the most expressive dimension(more selective power). e.g. real numbers are more granular than integers so they should be given priority.