skip to main content
Product overview : OpenAccess SDK configurations and IP implementation : Query optimization : Sequence of key constraints
 

Sequence of key constraints

One of the most common queries is of the form:
SELECT * FROM CURVALUE WHERE name IN(T1,T2,T3, ...)
This query should only retrieve rows that match the name specified in the name list. In this case if the IP reported that it could handle equality constraints and the column name is marked as an indexed column in the schema, then the OpenAccess SDK SQL engine passes to the IP a list that contains the values T1, T2 and T3. The IP can use this list to retrieve the matching rows and pass them to the OpenAccess SDK SQL engine for processing.