asterixdb-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Magnus Kongshem <>
Subject Limit clause
Date Wed, 06 Apr 2016 14:22:02 GMT

Performing a query with the limit clause, does this cause the query to stop
searching when it reaches the value of the limit parameter(like in SQL), or
does it keep searching for every matching object and then return the number
of objects specified by the limit? Example below:

use dataverse XXX;
from $obj in dataset YYY
    where $obj.timestamp >= 1412121600
    and $obj.timestamp <= 1412726400
    limit 2
return $obj;

Followup questions may occur.



Magnus Alderslyst Kongshem
+47 415 65 906

View raw message