In prior versions of Adaptive Server Enterprise, inserts into a partitioned data-only locked table with a placement index may cause wasted space. This waste is more pronounced in tables with a higher number of partitions and also for databases with larger page sizes.
Adaptive Server Enterprise version 12.5.3 avoids wasting extra space by filling up existing allocated extents in the target allocation page even though these extents are assigned to other partitions. The net effect is that we only allocate new extents when there are no free extents in the target allocation page.To turn off the new space allocation mechanism, activate command line trace flag 646 (-T646).
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
