If a table has max_rows_per_page set, and the table is converted from allpages locking to data-only locking, the value is converted to an exp_row_size value before the alter table...lock command copies the table to its new location. The exp_row_size is enforced during the copy.
|
If max_rows_per_page is Set to |
Set exp_row_size to |
|---|---|
|
0 |
Percentage value set by default exp_row_size percent |
|
255 |
1, that is, fully packed pages |
|
1 – 254 |
The smaller of:
|