Hello All,

Is it possible to have a query group (set of queries to run under an alias, label or module name) in Netezza.

Lets say I have few reports where each report has multiple queries - I would like to have a query group setup with an alias name as a report name such that we can capture the resource utilization of all the querys (probably using _v_plan_resource) for that particular group. Is this possible in Netezza ? Not sure if I have to create a resouce group for this?

Amazon Redshift has a similar concept called Query Group and I think Teradata has something called set labels.

Can someone please throw some light or give any alternative ideas if possible?

Thanks,

Santosh