Solutions
- To reduce contention for table blocks due to delete, select or update statements, reduce the number of rows per block. This can be done by using a smaller block size.
- To reduce contention for table blocks due to insert statements, increase the number of freelists, or buffer frames.
- To reduce contention for index blocks the best strategy is to implement a Reverse index.
In most situations the goal is to spread queries over a greater number of blocks, to avoid concentrating on any single one.
Read more about this topic: Block Contention
Famous quotes containing the word solutions:
“Science fiction writers foresee the inevitable, and although problems and catastrophes may be inevitable, solutions are not.”
—Isaac Asimov (1920–1992)
“Those great ideas which come to you in your sleep just before you awake in morning, those solutions to the world’s problems which, in the light of day, turn out to be duds of the puniest order, couldn’t they be put to some use, after all?”
—Robert Benchley (1889–1945)
“Football strategy does not originate in a scrimmage: it is useless to expect solutions in a political compaign.”
—Walter Lippmann (1889–1974)