If you need to retrieve the values, the fastest would probably be a stored generated column, not a virtual computed on the fly. In case you only want to filter

If you need to retrieve the values, the fastest would probably be a stored generated column, not a virtual computed on the fly. In case you only want to filter without returning values, you could also index directly on the expression without needing to add a stored generated column with an index on it