OWB performance tips
By Jean-Pierre Dijcks-Oracle on May 18, 2007
While looking at some websites to link for the Blog, I found Donna's performance tips (the site is linked now as well). I thought I directly link to that one, since it really is a good summary of practical tips.
I'd also wanted to comment on some other things on her website, since we are working hard to fix some of the issues mentioned on the page. One thing around the performance tips, we are adding explain plan and some other performance features into OWB 10.2.0.3 patch to fix some issues people were running into. Also having the plan information directly in the OWB GUI makes life easier (so we hope).
10.2.0.3 is also going to deliver the fixes to the SCD issues that some of you may have seen (and that Donna points out separately). In fact we are also adding hierarchy versioning directly in the tool. All in all quite exciting stuff! Stay tuned for release news on that patch.