Hello,
I’m curious about the impact of using multiple ‘OR’ conditions in a database search query, particularly regarding its effect on execution time. For instance, does employing 100 filters versus a single filter to delineate the search space affect the query’s performance? If so, could you provide an estimate on how the execution time increases with each additional filter?
Furthermore, my question extends to optimizing search queries. I’m exploring whether consolidating my current 100-filter query into a single, more comprehensive filter would maintain the same execution time, considering both approaches define the same search boundaries.