Need for Speed? 27 Mar ’09
Posted by: Steve Dickens
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!