When explaining a query in SQL Optimizer, if a partitioned table is touched by the SQL, that table (and its indexes, statistics, etc) doesn't show up on the Access Plan tab.
This problem happened for any partitioned table.
STATUS
Waiting for a fix with ST96450 on a future release of Quest SQL Optimizer for DB2.
WORKAROUND:
None
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy