Explain way to save space while inserting rows monotonically

Illustrates the way to save space while inserting rows monotonically?




If the columns which comprise the clustered index are monotonically rising (which is, new row key values are greater than those earlier inserted) the given System 11 dbcc tune will not split the page while it's half way full. Quite it'll let the page fill and after that allocate other page:

dbcc tune(ascinserts, 1, "my_table")

Incidentally, SyBooks is wrong when this states that the above requires to be reset while ASE is rebooted. It is a permanent setting not temporary.
To undo this:

dbcc tune (ascinserts, 0, "my _ table")

   Related Questions in Database Management System

2015 ┬ęTutorsGlobe All rights reserved. TutorsGlobe Rated 4.8/5 based on 34139 reviews.