Slow hubbledotnet query speed

If the match or contains condition is not found in the query conditions, the query method of this statement is to directly query the database and then return data.

It is not about index optimization in SQL.

Only match and contains can be used for full-text indexing. Otherwise, all queries are performed in the database.

Full text uses inverted indexes, while non-full text uses B-tree indexes. Hubble does not create B-tree indexes, because the database has already done a good job and Hubble has not compared and done it again.
Therefore, if the full-text query is not performed, the query is performed on the database, but the corresponding indexes of the database must be optimized.
Inverted indexes cannot be queried.