zOs/SQL/PLANHIRE

set current application compatibility 'V11R1';
select count(*), hint_used, remarks
    from cmnBatch.plan_table
    group by rollup(hint_used, remarks)
    with ur