DB2 10.5 on Windows Server 2012
I can have a query that takes 3 seconds to run and then when I look at the explain plan, it takes 2-5 minutes to generate. And it seems to be getting slower.
How can I speed this up? In my QA environment the same operation takes like 20 seconds to generate.
Jim
That seems pretty weird, Jim. It sounds like a resource conflict (perhaps a lock?) is getting in the way. An explain plan should generate quite quickly.