For querying search result items, we try 2 strategies:
the default strategy is always tried, and is usually the most performant
for certain searches where items are filtered to a small number of results, and ordered with a limit, the default strategy can be very slow, so we try a CTE strategy, with order and limit on a materialized view of the complete results, and we put it in a race with the default strategy
For querying search result items, we try 2 strategies: