Unanswered: IBM Data Studio 220.127.116.11 performance versus IBM OSC 1.1. FP7
We installed IBM Data Studio 18.104.22.168 as IBM OSC will be decommissioned soon . While comparing both , it seems that Data Studio is much slower for some queries with many joins while doing access plan graph (300 secs for Data Studio where step "Show Formatter" lasted 280 secs) compared to less than 10 seconds for OSC .
Does anyone has experienced the same trouble ?
INNER JOIN T3 ON C1 = T3.C6
INNER JOIN T2 on T1.C5 = T2.C1
optimize for 1 row
Performance for both are similar for simple selects without these joins .