Query Performance is it HW, SW or Design

Goal
Predictable performance to Ad-Hoc Queries
we do not compete with pre-run or cached reports

Alternatives
HW Change: get more powerful HW, get additional HW, i.e. BI Accelerator, add memory, etc
SW Change: change database, change DW software, Teradata, BI Accelerator, Neoview, Upgrade BI, etc
Design: Single EDW Architecture, enhance Architecture, Modeling, Automated InfoCube modeling

note: BIA comes both in HW and SW as it is an appliance consisting of both

Findings
Reported=by vendor; tested= real life
Nx= times faster

HW Change/ Performance improvement
Can result reported improvement 04x-5x
BIA can result in tested at 18-60x
Add memory tested 03x-05x

SW Change:

Oracle to DB2 reported a max of 18x-20x
but has other issues that must be considered
non SAP solutions 40x-60x
Oracle, Teradata, nateeza, but add integration costs
BI Accelerator tested at 18x-60x
BI UpgradeUpgrade plan for 01x-02xc
note: ould degrade performance with functionality changes.

Design / Performance
Multi > Single EDW tested at 04x-08x
in cross SBU reports;
Enhance Architecture 02x-05x
Automated modeling 30x-50x

Collaboration / Performance
Automated InfoCube modeling 30x-50x
with BIA tested 100x-180x

for more details revert to author