Clone
Anoop Sharma <anoop.sharma@esgyn.com>
committed
on 11 Jul 17
TRAFODION-2683 add a new explain option to mask variant fields in output
--Syntax extension to cleanse and mask:
explain options 'c' selec… Show more
TRAFODION-2683 add a new explain option to mask variant fields in output

--Syntax extension to cleanse and mask:

 explain options 'c' select ...

 explain options 'fc' select...

 prepare s from select ...

 explain option 'c' s;

--Masked fields will show up as "###" in explain output.

--Both option and options keyword can be used in explain and showplan.

   -- explain option/options ...

   -- showplan option/options ...

-- showplan can be used on explain statement.

-- Here is an example of what the output will look like:

>>explain option 'c' select * from dual;

----------------------------------------------- PLAN SUMMARY

MODULE_NAME .............. DYNAMICALLY COMPILED

STATEMENT_NAME ........... NOT NAMED

PLAN_ID ................ ###

ROWS_OUT ............... ###

EST_TOTAL_COST ......... ###

STATEMENT ................ select * from dual;

------------------------------------------- NODE LISTING

ROOT ================================  SEQ_NO 2        ONLY CHILD 1

REQUESTS_IN ............ ###

ROWS_OUT ............... ###

EST_OPER_COST .......... ###

EST_TOTAL_COST ......... ###

DESCRIPTION

 max_card_est ......... ###

 fragment_id ............ 0

 parent_frag ............ (none)

 fragment_type .......... master

 statement_index ........ 0

 affinity_value ....... ###

 max_max_cardinality    ###

 total_overflow_size    ###

 xn_access_mode ......... read_only

 xn_autoabort_interval    0

 auto_query_retry ....... enabled

 plan_version ....... 2,600

 embedded_arkcmp ........ used

 select_list ............ %(0)

 input_variables ........ %(0), %(0), %(0)

VALUES ========================  SEQ_NO 1        NO CHILDREN

REQUESTS_IN ............ ###

ROWS_OUT ............... ###

EST_OPER_COST .......... ###

EST_TOTAL_COST ......... ###

DESCRIPTION

 max_card_est ......... ###

 fragment_id ............ 0

 parent_frag ............ (none)

 fragment_type .......... master

 tuple_expr ............. %(0)

--- SQL operation complete.

>>

Show less

default + 4 more