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>).
Predicates that use IN (see example).

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;

Copy