Filter
Top Products
235
Performance Considerations for Streams and Nodes
offset value is not a literal integer; for example, @OFFSET(Sales, Month). The offset value is the
field name Mont
h, whose value is unknown until executed. The server must save all values of the
Sales field to ensur e accurate results. Where an uppe r bound is known, you should provide it as
an additional argument; for example, @OFFSET(Sales, Month, 12). This operat ion instructs the
server to sto
re no more than the 12 most recent values of Sales. Sequence functions, bounded or
otherwise, almost always inhibit SQL generation.