Improve performance of contains expression #2972
Description
What is the problem the feature request solves?
CometStringExpressionBenchmark shows poor performance for contains:
OpenJDK 64-Bit Server VM 11.0.22+7-LTS on Mac OS X 14.6.1
Apple M3 Max
contains: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
Spark 10 69 27 0.1 9603.6 1.0X
Comet (Scan) 11 81 26 0.1 10928.1 0.9X
Comet (Scan + Exec) 44 91 20 0.0 42889.5 0.2X
Describe the potential solution
Review benchmark to make sure it is valid, then try and optimize performance.
Additional context
No response