Menu Request Demo

Need for Speed?

27 March 2009

A client site of mine had a detail report that was running in BW over MaxDB that was taking 5-15 minutes to return a small selection of data.
The report was pretty much unusable which frustrated key users in the business as the subject area was of key interest to them.
As a proof of concept I combined my business knowledge and SQL skills with Doug’s Reporting Services knowledge and SQL skills and recreated the very slow report.
The source fact table has 200 million rows in it and is partitioned by month.
Without any additional performance improving indexes the report now runs in 2-4 seconds!


Comments 0

Leave a Comment

No comments.