zOs/SQL/EXPLAIQY
--- temporary explain --------------------------------------------------
set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_STATEMNT_TABLE;
delete from A540769.DSN_DetCost_TABLE ;
delete from A540769.dsn_filter_Table ;
delete from A540769.dsn_predicat_table;
explain plan set queryno = 3 for
select substr(db, 1, 8) "db"
, substr(ts, 1, 8) "ts"
, substr(ix, max(1, length(ix) - 7), 8) "...index"
, substr(case when part = 0 then ''
else value(right(' '||strip(char(part)), 4), '----')
||'/'|| value(right(' '||strip(char(tsParts)), 4),'----') )
end, 1, 9) "part/ tot"
, substr(right(' ' || int(round(actGb)), 6), 1, 6) "usedGB"
, substr(right(' ' || int(round(limGb/100*schwelle))
, 6), 1, 6) "schwGB"
, substr(right(' ' || schwelle, 5), 1, 5) "schw%"
, substr(right(' ' || int(round(limGb)), 6), 1, 6) "limGB"
, tsTy "y"
, substr(schwinfo, 7, 35) "schwellwert key"
from oa1p.vQz006gbGrenze
where actGb > real(limGb / 100 * schwelle)
and db <> 'DSNDB01' -- directory ist anders
and rz = 'RZX' and dbSys = 'DE0G'
order by db, ts, part, ix
;
select * from plan_view1
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2det
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select *
from plan_viewPred
order by collid, progName, explain_time,
queryNo, qBlockNo, predNo, orderNo, mixOpSeqNo
with ur
;
rollback
;;;;
--- temporary explain --------------------------------------------------
set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_STATEMNT_TABLE;
delete from A540769.DSN_DetCost_TABLE ;
delete from A540769.dsn_filter_Table ;
delete from A540769.dsn_predicat_table;
explain plan set queryno = 81 for
insert into OA1P.TQZ007GBGRIXSTATS
select 'a' STATE
, 'RZX' RZ
, 'DEVG' DBSYS
, '2014-07-14-07.23.43.062215' LOADTS
, INDEXTYPE
, COMPRESS
, IXPARTS
, IXPGSZ
, PIECESIZE
, PIECEGB
, LIMGB
, TBCREATOR
, TBNAME
, TS
, TSTY
, TSPARTS
, TSCLONE
, TSINST
, TSDSSIZE
, TSDSGB
, TSLimGb
, TSLimPart
, TSPGSZ
, UPDATESTATSTIME
, NLEVELS
, NPAGES
, NLEAF
, NACTIVE
, SPACE
, EXTENTS
, LOADRLASTTIME
, REBUILDLASTTIME
, REORGLASTTIME
, REORGINSERTS
, REORGDELETES
, REORGAPPENDINSERT
, REORGPSEUDODELETES
, REORGMASSDELETE
, REORGLEAFNEAR
, REORGLEAFFAR
, REORGNUMLEVELS
, STATSLASTTIME
, STATSINSERTS
, STATSDELETES
, STATSMASSDELETE
, COPYLASTTIME
, COPYUPDATEDPAGES
, COPYCHANGES
, COPYUPDATELRSN
, COPYUPDATETIME
, LASTUSED
, IBMREQD
, DBID
, ISOBID
, PSID
, PARTITION
, INSTANCE
, TOTALENTRIES
, DBNAME
, NAME
, CREATOR
, INDEXSPACE
, REORGINDEXACCESS
, DRIVETYPE
, STATS101
from OA1P.TQZ007GBGRIXSTATS n
where n.rz = '?' and n.dbSys = '?'
and not exists ( select 1
from OA1P.TQZ007GBGRIXSTATS b join
(
select rz, dbSys, dbName, ts, indexSpace
, partition, instance, max(loadTs) loadTs
from OA1P.TQZ007GBGRIXSTATS a
where rz='RZX' and dbSys = 'DEVG'
and n.dbName = a.dbName
and n.ts = a.ts
and n.indexSpace= a.indexSpace
and n.partition = a.partition
and n.instance = a.instance
group by rz, dbSys, dbName, ts, indexSpace
, partition, instance
) a
on b.rz = a.rz
and b.dbSys = a.dbSys
and b.dbName = a.dbName
and b.ts = a.ts
and b.indexSpace= a.indexSpace
and b.partition = a.partition
and b.instance = a.instance
and b.loadTS = a.loadTs
where b.updateStatsTime = n.updateStatsTime
)
;
explain plan set queryno = 82 for
insert into OA1P.TQZ007GBGRIXSTATS
select 'a' STATE
, 'RZX' RZ
, 'DEVG' DBSYS
, '2014-07-14-07.23.43.062215' LOADTS
, INDEXTYPE
, COMPRESS
, IXPARTS
, IXPGSZ
, PIECESIZE
, PIECEGB
, LIMGB
, TBCREATOR
, TBNAME
, TS
, TSTY
, TSPARTS
, TSCLONE
, TSINST
, TSDSSIZE
, TSDSGB
, TSLimGb
, TSLimPart
, TSPGSZ
, UPDATESTATSTIME
, NLEVELS
, NPAGES
, NLEAF
, NACTIVE
, SPACE
, EXTENTS
, LOADRLASTTIME
, REBUILDLASTTIME
, REORGLASTTIME
, REORGINSERTS
, REORGDELETES
, REORGAPPENDINSERT
, REORGPSEUDODELETES
, REORGMASSDELETE
, REORGLEAFNEAR
, REORGLEAFFAR
, REORGNUMLEVELS
, STATSLASTTIME
, STATSINSERTS
, STATSDELETES
, STATSMASSDELETE
, COPYLASTTIME
, COPYUPDATEDPAGES
, COPYCHANGES
, COPYUPDATELRSN
, COPYUPDATETIME
, LASTUSED
, IBMREQD
, DBID
, ISOBID
, PSID
, PARTITION
, INSTANCE
, TOTALENTRIES
, DBNAME
, NAME
, CREATOR
, INDEXSPACE
, REORGINDEXACCESS
, DRIVETYPE
, STATS101
from OA1P.TQZ007GBGRIXSTATS n
where n.rz = '?' and n.dbSys = '?'
and not exists ( select 1
from OA1P.TQZ007GBGRIXSTATS a
where rz='RZX' and dbSys = 'DEVG'
and n.dbName = a.dbName
and n.ts = a.ts
and n.indexSpace= a.indexSpace
and n.partition = a.partition
and n.instance = a.instance
and n.updateStatsTime = a.updateStatsTime
and a.loadTs = (select max(b.loadTs)
from OA1P.TQZ007GBGRIXSTATS b
where b.rz = a.rz
and b.dbSys = a.dbSys
and b.dbName = a.dbName
and b.ts = a.ts
and b.indexSpace= a.indexSpace
and b.partition = a.partition
and b.instance = a.instance
)
)
;
explain plan set queryno = 84 for
insert into OA1P.TQZ007GBGRIXSTATS
select 'a' STATE
, 'RZX' RZ
, 'DEVG' DBSYS
, '2014-07-14-07.23.43.062215' LOADTS
, INDEXTYPE
, COMPRESS
, IXPARTS
, IXPGSZ
, PIECESIZE
, PIECEGB
, LIMGB
, TBCREATOR
, TBNAME
, TS
, TSTY
, TSPARTS
, TSCLONE
, TSINST
, TSDSSIZE
, TSDSGB
, TSLimGb
, TSLimPart
, TSPGSZ
, UPDATESTATSTIME
, NLEVELS
, NPAGES
, NLEAF
, NACTIVE
, SPACE
, EXTENTS
, LOADRLASTTIME
, REBUILDLASTTIME
, REORGLASTTIME
, REORGINSERTS
, REORGDELETES
, REORGAPPENDINSERT
, REORGPSEUDODELETES
, REORGMASSDELETE
, REORGLEAFNEAR
, REORGLEAFFAR
, REORGNUMLEVELS
, STATSLASTTIME
, STATSINSERTS
, STATSDELETES
, STATSMASSDELETE
, COPYLASTTIME
, COPYUPDATEDPAGES
, COPYCHANGES
, COPYUPDATELRSN
, COPYUPDATETIME
, LASTUSED
, IBMREQD
, DBID
, ISOBID
, PSID
, PARTITION
, INSTANCE
, TOTALENTRIES
, DBNAME
, NAME
, CREATOR
, INDEXSPACE
, REORGINDEXACCESS
, DRIVETYPE
, STATS101
from OA1P.TQZ007GBGRIXSTATS n
where n.rz = '?' and n.dbSys = '?'
and updatestatsTime <> value(( select timestamp(substr(max(
char(loadTs) || char(updateStatsTime)), 27))
from OA1P.TQZ007GBGRIXSTATS a
where rz='RZX' and dbSys = 'DEVG'
and n.dbName = a.dbName
and n.ts = a.ts
and n.indexSpace= a.indexSpace
and n.partition = a.partition
and n.instance = a.instance
), '1111-11-11-11.11.11')
;
select * from plan_view1
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2det
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select *
from plan_viewPred
order by collid, progName, explain_time,
queryNo, qBlockNo, predNo, orderNo, mixOpSeqNo
with ur
;
rollback
;;;;
--- temporary explain --------------------------------------------------
set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_STATEMNT_TABLE;
delete from A540769.DSN_DetCost_TABLE ;
delete from A540769.dsn_filter_Table ;
delete from A540769.dsn_predicat_table;
explain plan set queryno = 51 for
select count(*), sum(real(totalEntries))
from OA1P.TQZ007GBGRixSTATS a
where rz = 'RZX' and dbSys = 'DEVG'
and loadTs = (select max(loadTs)
from OA1P.TQZ007GBGRIXSTATS r
where r.rz = a.rz
and r.dbSys = a.dbSys
and r.dbName = a.dbName
and r.ts = a.ts
and r.indexSpace= a.indexSpace
and r.partition = a.partition
and r.instance = a.instance
and r.loadTS = a.loadTs
)
;
explain plan set queryno = 52 for
with a as
(
select a.*
, row_number() over(partition by rz, dbSys, dbName, ts, indexSpace
, partition, instance
order by loadts desc) ln
from OA1P.TQZ007GBGRixSTATS a
)
select count(*), sum(real(totalEntries))
from a
where ln = 1 and rz = 'RZX' and dbSys = 'DEVG'
;
explain plan set queryno = 53 for
with k as
(
select rz, dbSys, dbName, ts, indexSpace, partition, instance
, max(loadTs) loadTs
from OA1P.TQZ007GBGRixSTATS
group by rz, dbSys, dbName, ts, indexSpace, partition, instance
)
select count(*), sum(real(i.totalEntries))
from OA1P.TQZ007GBGRixSTATS i
join k
on i.rz = k.rz
and i.dbSys = k.dbSys
and i.dbName = k.dbName
and i.ts = k.ts
and i.indexSpace= k.indexSpace
and i.partition = k.partition
and i.instance = k.instance
and i.loadTS = k.loadTs
where i.rz = 'RZX' and i.dbSys = 'DEVG'
;
select * from plan_view1
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2det
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select *
from plan_viewPred
order by collid, progName, explain_time,
queryNo, qBlockNo, predNo, orderNo, mixOpSeqNo
with ur
;
rollback
;;;;
??????????????
--- temporary explain --------------------------------------------------
set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_STATEMNT_TABLE;
delete from A540769.DSN_DetCost_TABLE ;
delete from A540769.dsn_filter_Table ;
delete from A540769.dsn_predicat_table;
delete from A540769.dsn_struct_table;
explain plan set queryno = 30 for
insert into OA1P.TQZ006GBGRTSSTATS
(state, loadTs, rz, dbSys, dbName, name, partition, instance
, tsType, tsTy, pgSize, segSize
, parts, maxParts, dsSize, dsGb, limGb, limPart
, obid, clone, tsInst, tbCr, tb, tbTy, tbObId
, dbid, psid, ibmReqD
, updateStatsTime)
select 'd', '2014-06-23-06.56.26.593270'
, rz, dbSys, dbName, name, partition, instance
, tsType, tsTy, pgSize, segSize
, parts, maxParts, dsSize, dsGb, limGb, limPart
, obid, clone, tsInst, tbCr, tb, tbTy, tbObId
, dbid, psid, ibmReqD
, (select max(updateStatsTime)
from OA1P.TQZ006GBGRTSSTATS n
where n.rz = '?' and n.dbSys = '?'
)
from OA1P.TQZ006GBGRTSSTATS s
where rz = 'RZ2' and dbSys = 'DBOF' and state <> 'd'
and loadTs = (select max(loadTs)
from OA1P.TQZ006GBGRTSSTATS a
where a.rz = s.rz and a.dbSys = s.dbSys
and a.dbName = s.dbName
and a.Name = s.Name
and a.partition = s.partition
and a.instance = s.instance
)
and not exists (select 1
from OA1P.TQZ006GBGRTSSTATS n
where n.rz = '?' and n.dbSys = '?'
and n.dbName = s.dbName
and n.Name = s.Name
and n.partition = s.partition
and n.instance = s.instance
)
;
explain plan set queryno = 32 for
insert into OA1P.TQZ006GBGRTSSTATS
(state, loadTs, rz, dbSys, dbName, name, partition, instance
, tsType, tsTy, pgSize, segSize
, parts, maxParts, dsSize, dsGb, limGb, limPart
, obid, clone, tsInst, tbCr, tb, tbTy, tbObId
, dbid, psid, ibmReqD
, updateStatsTime)
select 'd', '2014-06-23-06.56.26.593270'
, rz, dbSys, dbName, name, partition, instance
, tsType, tsTy, pgSize, segSize
, parts, maxParts, dsSize, dsGb, limGb, limPart
, obid, clone, tsInst, tbCr, tb, tbTy, tbObId
, dbid, psid, ibmReqD
, (select max(updateStatsTime)
from OA1P.TQZ006GBGRTSSTATS n
where n.rz = '?' and n.dbSys = '?'
)
from OA1P.TQZ006GBGRTSSTATS s
where state <> 'd'
and (rz, dbSys, dbName, name
, partition, instance, loadTs) in
(select rz, dbSys, dbName, name
, partition, instance, max(loadTs) loadTs
from OA1P.TQZ006GBGRTSSTATS j
where rz='RZ2' and dbSys = 'DBOF'
group by rz, dbSys, dbName, name
, partition, instance
)
and not exists (select 1
from OA1P.TQZ006GBGRTSSTATS n
where n.rz = '?' and n.dbSys = '?'
and n.dbName = s.dbName
and n.Name = s.Name
and n.partition = s.partition
and n.instance = s.instance
)
;
explain plan set queryno = 33 for
insert into OA1P.TQZ006GBGRTSSTATS
(state, loadTs, rz, dbSys, dbName, name, partition, instance
, tsType, tsTy, pgSize, segSize
, parts, maxParts, dsSize, dsGb, limGb, limPart
, obid, clone, tsInst, tbCr, tb, tbTy, tbObId
, dbid, psid, ibmReqD
, updateStatsTime)
with j as
(
select rz, dbSys, dbName, name
, partition, instance, max(loadTs) loadTs
from OA1P.TQZ006GBGRTSSTATS j
where rz='RZ2' and dbSys = 'DBOF'
group by rz, dbSys, dbName, name
, partition, instance
)
select 'd', '2014-06-23-06.56.26.593270'
, s.rz, s.dbSys, s.dbName, s.name, s.partition, s.instance
, tsType, tsTy, pgSize, segSize
, parts, maxParts, dsSize, dsGb, limGb, limPart
, obid, clone, tsInst, tbCr, tb, tbTy, tbObId
, dbid, psid, ibmReqD
, (select max(updateStatsTime)
from OA1P.TQZ006GBGRTSSTATS n
where n.rz = '?' and n.dbSys = '?'
)
from OA1P.TQZ006GBGRTSSTATS s
join j
on s.rz = j.rz
and s.dbSys = j.dbSys
and s.dbName = j.dbName
and s.Name = j.Name
and s.partition = j.partition
and s.instance = j.instance
and s.loadTS = j.loadTs
where state <> 'd'
and not exists (select 1
from OA1P.TQZ006GBGRTSSTATS n
where n.rz = '?' and n.dbSys = '?'
and n.dbName = s.dbName
and n.Name = s.Name
and n.partition = s.partition
and n.instance = s.instance
)
;
explain plan set queryno = 37 for
select rz, dbSys, dbName, name
, partition, instance, max(loadTs)
from OA1P.TQZ006GBGRTSSTATS j
where rz='RZ2' and dbSys = 'DBOF'
group by rz, dbSys, dbName, name
, partition, instance
;
explain plan set queryno = 34 for
insert into OA1P.TQZ006GBGRTSSTATS
with a as
(
select rz, dbSys, dbName, name
, partition, instance, max(loadTs) loadTs
from OA1P.TQZ006GBGRTSSTATS a
where rz='RZ2' and dbSys = 'DBOF'
group by rz, dbSys, dbName, name, partition, instance
)
, b as
(
select b.*
from OA1P.TQZ006GBGRTSSTATS b join a
on b.rz = a.rz
and b.dbSys = a.dbSys
and b.dbName = a.dbName
and b.Name = a.Name
and b.partition = a.partition
and b.instance = a.instance
and b.loadTS = a.loadTs
)
select 'a' STATE
, 'RZ2' RZ
, 'DBOF' DBSYS
, '2014-06-24-16.06.14.269185' LOADTS
, TSTYPE
, TSTY
, PGSIZE
, SEGSIZE
, PARTS
, MAXPARTS
, DSSIZE
, DSGB
, LIMGB
, LIMPART
, OBID
, CLONE
, TSINST
, TBCR
, TB
, TBTY
, TBOBID
, UPDATESTATSTIME
, NACTIVE
, NPAGES
, EXTENTS
, LOADRLASTTIME
, REORGLASTTIME
, REORGINSERTS
, REORGDELETES
, REORGUPDATES
, REORGUNCLUSTINS
, REORGDISORGLOB
, REORGMASSDELETE
, REORGNEARINDREF
, REORGFARINDREF
, STATSLASTTIME
, STATSINSERTS
, STATSDELETES
, STATSUPDATES
, STATSMASSDELETE
, COPYLASTTIME
, COPYUPDATEDPAGES
, COPYCHANGES
, COPYUPDATELRSN
, COPYUPDATETIME
, IBMREQD
, DBID
, PSID
, PARTITION
, INSTANCE
, SPACE
, TOTALROWS
, DATASIZE
, UNCOMPRESSEDDATASIZE
, DBNAME
, NAME
, REORGCLUSTERSENS
, REORGSCANACCESS
, REORGHASHACCESS
, HASHLASTUSED
, DRIVETYPE
, LPFACILITY
, STATS01
from OA1P.TQZ006GBGRTSSTATS n
where n.rz = '?' and n.dbSys = '?'
and not exists
( select 1
from b o
where o.rz = 'RZ2' and o.dbSys = 'DBOF'
and o.dbName = n.dbName
and o.name = n.name
and o.partition = n.partition
and o.instance = n.instance
and o.updateStatsTime = n.updateStatsTime
)
;
explain plan set queryno = 35 for
insert into OA1P.TQZ006GBGRTSSTATS
select 'a' STATE
, 'RZ2' RZ
, 'DBOF' DBSYS
, '2014-06-24-16.06.14.269185' LOADTS
, TSTYPE
, TSTY
, PGSIZE
, SEGSIZE
, PARTS
, MAXPARTS
, DSSIZE
, DSGB
, LIMGB
, LIMPART
, OBID
, CLONE
, TSINST
, TBCR
, TB
, TBTY
, TBOBID
, UPDATESTATSTIME
, NACTIVE
, NPAGES
, EXTENTS
, LOADRLASTTIME
, REORGLASTTIME
, REORGINSERTS
, REORGDELETES
, REORGUPDATES
, REORGUNCLUSTINS
, REORGDISORGLOB
, REORGMASSDELETE
, REORGNEARINDREF
, REORGFARINDREF
, STATSLASTTIME
, STATSINSERTS
, STATSDELETES
, STATSUPDATES
, STATSMASSDELETE
, COPYLASTTIME
, COPYUPDATEDPAGES
, COPYCHANGES
, COPYUPDATELRSN
, COPYUPDATETIME
, IBMREQD
, DBID
, PSID
, PARTITION
, INSTANCE
, SPACE
, TOTALROWS
, DATASIZE
, UNCOMPRESSEDDATASIZE
, DBNAME
, NAME
, REORGCLUSTERSENS
, REORGSCANACCESS
, REORGHASHACCESS
, HASHLASTUSED
, DRIVETYPE
, LPFACILITY
, STATS01
from OA1P.TQZ006GBGRTSSTATS n
where n.rz = '?' and n.dbSys = '?'
and not exists ( select 1
from OA1P.TQZ006GBGRTSSTATS b join
(
select rz, dbSys, dbName, name
, partition, instance, max(loadTs) loadTs
from OA1P.TQZ006GBGRTSSTATS a
where rz='RZ2' and dbSys = 'DBOF'
and n.dbName = a.dbName
and n.Name = a.Name
and n.partition = a.partition
and n.instance = a.instance
group by rz, dbSys, dbName, name, partition, instance
) a
on b.rz = a.rz
and b.dbSys = a.dbSys
and b.dbName = a.dbName
and b.Name = a.Name
and b.partition = a.partition
and b.instance = a.instance
and b.loadTS = a.loadTs
and b.updateStatsTime = n.updateStatsTime
)
; mm
explain plan set queryno = 38 for
with j as
(
select rz, dbSys, dbName, name
, partition, instance, max(loadTs) loadTs
from OA1P.TQZ006GBGRTSSTATS j
where rz='RZ2' and dbSys = 'DBOF'
group by rz, dbSys, dbName, name
, partition, instance
)
select s.*
from OA1P.TQZ006GBGRTSSTATS s join j
on s.rz = j.rz
and s.dbSys = j.dbSys
and s.dbName = j.dbName
and s.Name = j.Name
and s.partition = j.partition
and s.instance = j.instance
and s.loadTS = j.loadTs
;
select * from plan_view1
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2det
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select *
from plan_viewPred
order by collid, progName, explain_time,
queryNo, qBlockNo, predNo, orderNo, mixOpSeqNo
with ur
;
select * from A540769.dsn_struct_table where queryno = 30;
rollback
;;;;
--- temporary explain --------------------------------------------------
set current sqlid = 'A540769';
delete from A540769.plan_table;
delete from A540769.DSN_STATEMNT_TABLE;
delete from A540769.DSN_DetCost_TABLE ;
delete from A540769.dsn_filter_Table ;
delete from A540769.dsn_predicat_table;
delete from A540769.dsn_struct_table;
explain plan set queryno = 1 for
with a as
(
select rz, dbSys, dbName, name
, partition, instance, max(loadTs) loadTs
from OA1P.TQZ006GBGRTSSTATS a
group by rz, dbSys, dbName, name, partition, instance
)
, b as
(
select b.*
from OA1P.TQZ006GBGRTSSTATS b join a
on b.rz = a.rz
and b.dbSys = a.dbSys
and b.dbName = a.dbName
and b.Name = a.Name
and b.partition = a.partition
and b.instance = a.instance
and b.loadTS = a.loadTs
)
select * from b where rz = 'RZ2' and dbSys = 'DVBP'
and dbName = 'MF01A1P'
;
select * from plan_view1
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select * from plan_view2det
order by -- collid, progName, version, explain_time,
queryNo, qblockno, planno, mixOpSeq
;
select *
from plan_viewPred
order by collid, progName, explain_time,
queryNo, qBlockNo, predNo, orderNo, mixOpSeqNo
with ur
;
select * from A540769.dsn_struct_table;
rollback
;;;;