BigQuery search indexes optimizations for the SEARCH function predicate and others such as = (EQUAL), IN, STARTS_WITH and limited LIKE.
For any question search indexes, please contact us at bq-search-team@google.com.