In some ways I found this a little surprising; however the final paragraph about real working data not being accessed as randomly as you think is my experience.
I'm curious about ways to live automatically tune this. You can use SET LOCAL to transaction scope a value, yet this would mean managing it completely in your application.
In some ways I found this a little surprising; however the final paragraph about real working data not being accessed as randomly as you think is my experience.
I'm curious about ways to live automatically tune this. You can use SET LOCAL to transaction scope a value, yet this would mean managing it completely in your application.