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).


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;