SAP SE
UNIQUE KEY LOOKUP WITH ADDITIONAL FILTER

Abstract:

A method, a system, and a computer program product for executing a query. The query requiring access to one or more tables stored in a database system is executed. The query includes one or more filter predicates. Using a unique key value corresponding to a first predicate, at most one row in the tables including a portion of data matching the unique key value is identified. Using filter values corresponding to the filter predicates, another portion of data in the identified row is compared to the filter values to determine whether that portion of data matches the filter values. Based on the comparison, a result of the execution of the query is outputted. The result includes data stored in the identified row upon determination that the data matches the unique key value corresponding to the first filter predicate and the filter values corresponding to remaining filter predicates. Otherwise, the result is empty.