Name
DB.DBA.BAG_AGG — Returns a vector of passed values.
Synopsis
vector
DB.DBA.BAG_AGG
(
|
value_expression
any
); |
Description
DB.DBA.BAG_AGG() returns a vector of passed values.
This is similar to DB.DBA.VECTOR_AGG() and returns a vector of passed values but the order of items in the vector is not predefined and may vary from run to run.
A query with DB.DBA.BAG_AGG() may work faster than a
similar query with
DB.DBA.VECTOR_AGG() because
DB.DBA.BAG_AGG() gives more freedom to the SQL
optimizer. If the order is not important for your application, consider
using of DB.DBA.BAG_AGG().
Parameters
value_expression
Value of item for aggregation.
Return Types
Any
Examples
Example 24.6. Simple Use
SELECT DB.DBA.BAG_AGG (subquery.X)
FROM (SELECT X FROM ... ORDER BY X) as subquery