Hi,

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!