How are indexes compiled with a large number of different queries?

Question

MySQL

In general, the question is simple, but no one can clearly answer it.
1. Let's say there is a table / collection in which in theory there will be a lot of records, let's start reasoning from 100 GB. and the number of these data will only grow.
2. There is a user part, where there are many parameters for filtering, let's say about 20+.
There can be a lot of query options, how are indexes generally compiled in such cases?

Answer 1

are you sure you need to search in sql database? can think and look, for example, in the direction of the elastic?

Answer 2

Try clickhouse

Answer 3

Depends on the specific example, as an option, you can use (partially use) a faceted filter.