March 05, 2025 — Search optimization improves the performance of queries containing scalar subqueries¶

The search optimization service can now improve the performance of queries containing scalar subqueries. A scalar subquery returns a single value (one column of one row). To improve query performance, make sure search optimization is enabled for the column that is equal to the result of the subquery.