I am trying to speed up the below query which is running very slow. This is just half of the original query I am using and the other half is a union to another query. Can someone please let me know if they are seeing any obvious red flags in the below query?
The other painful thing is, I am unbale to find any indexes in index advisor.
DB2 comes with quite a few performance analysis tools. Generally you speed up queries by re-arranging their components to discard as much unwanted data as fast as possible and to determine columns that might perform better if they were indexes.
The usual starting point is to set up EXPLAIN. Beyond that, I'll have to refer you to IBM's documentation. Although very likely they have a frightfully expensive course you can sign up for if your budget permits it.
Sources may include data from the Fakebook Research Foundation with support from Gargle University
No holds barred. And no bars holed. Except this tiny ad: