How to estimate the impact of BWA?

[former_member341062]

Hi,

Maybe I'm not looking in the right places, but I can't find any information on how to estimate the inpact to query runtime by introducing BWA. Most articles contain statistics that show that "there was improved performance" based on before and after measurements. I'd like to calculate the approximate effect before buying the system

Should I assume DB time ->0 and keep the rest of the query performance stats or is there a better model?

Regards

Ola

[Vitaliy-R]

Ola, DB time does not go to '0', the world is not perfect. The result time of the query execution by BWA as well greatly depends on the number of records returned - DBTRANS in RSDDSTAT_DM. Sorry. -Vitaliy