April 15, 2025 — Search optimization improves the performance of queries containing scalar fucntions

The search optimization service can now improve the performance of queries containing scalar functions. A scalar function returns a single value for each invocation. The search optimization service can improve the performance of queries that use scalar functions in equality predicates. The scalar function can be a system-defined scalar function or a user-defined scalar SQL function.

For more information, see Speeding up queries with scalar functions using search optimization.