1 query hint would be what the full set of "visibility" possibilities are (or at least whether there is more than 1 visibility per adapter). If there is only 1 visibility throughout, then the whole row iterator is unnecessary.

another query hint is whether there is ever a duplicate per adapter-index pair (or perhaps the max number of duplicates)

another query hint is the filled tiers (some tiers may not have any data, the base case of point-timestamps only would just be a single tier). We only need to query the tiers that have data.