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.