Explain plan not showing partition access via KEY (4225917)

Explain plan in TOAD is showing blank in the partition info column even though the explain plan table entry indicates that partition start and partition stop are set to the value KEY. If pstart and pstop contain partition numbers, then the info is displayed correctly.

1. Close Toad.

2. Please edit ExplainPlancolumnDefs.xml in the user files directory as follows:

Please change these lines:

<Column id="6" show="0" shown="0" type="s" name="Part Start" attr="partition_start" color="clBlack"/>
<Column id="7" show="0" shown="0" type="s" name="Part Stop" attr="partition_stop" color="clBlack"/>

to this

<Column id="6" show="1" shown="0" type="s" name="Part Start" attr="partition_start" color="clBlack"/>
<Column id="7" show="1" shown="0" type="s" name="Part Stop" attr="partition_stop" color="clBlack"/>

In both lines, show = 0 changed to show = 1.

3. Start toad, do an explain plan, right-click to adjust content, and include Part Start and Part Stop.