Speeding up point lookup queries with search optimization¶
Point lookup queries are queries that are expected to return a small number of rows. The search optimization service can improve the performance of point lookup queries that use:
Equality predicates (for example,
<column_name> = <constant>
).
Example¶
The IN clause is supported by the search optimization service:
select id, c1, c2, c3
from test_table
where id IN (2, 3)
order by id;