skip to main content
Product overview : OpenAccess SDK configurations and IP implementation : Query optimization : Key and time constraints
 

Key and time constraints

Another common situation is to add time constraints to a query:
SELECT * FROM archive WHERE name= 'T1' AND time BETWEEN 'jan 1,1995' AND 'jan 2,1995'
This must be recognized by the IP as a special pattern in order to efficiently handle the processing. The OpenAccess SDK SQL engine will recognize this pattern and give the IP the name and time parameters. The IP can then access just the data for the specified name within the specified time limits.