Provides the ability to produce a query plan from any query that exists in the Statement Cache. Once a query is in the cache, there may be some question if it was cached with the proper query plan. Since there is no current way to confirm this, we now have a way to view the plan.
Why is it useful?
|Who would benefit from this IDEA?|
How should it work?
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "email@example.com" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions