var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: bufferpool hit ratio
After stopping / starting the db, I ran a query that gave me back the sum of data for a year and I got a bufferpool hit ratio of 72%.
When I run the command again, I got a BP hit ratio of 100%
Then, I tried to get the sum for a different id ( than above) and I got a bp hit ratio of 81% and the second time, I get 100%.
Then tried another new id and got 77% as the bp hit ratio and then 100% second time around...
Also, got 24% for another unique id and then 100% second time around..
Would you consider these satisfactory results? Thx!
Last edited by db2user24; 06-02-11 at 19:45.