Hi All,
I have a DB2 SQL view created with below statement:
The problem I am facing is kind of strange. When we do a select * on this view, it runs slow for the first few times every new session. But then after 2 to 3 executions, the speed improves drastically and execution time reduces to 2 seconds from the initial 40 seconds.
Can someone guide on any possible optimizations: