September 2010
Intermediate to advanced
1704 pages
111h 8m
English
One of the most useful features of partitioned tables is that you can add and drop entire partitions of table data in bulk. If the table partitions are set up properly, these commands can take place in seconds, without the expensive input/output (I/O) costs of physically copying or moving the data. You can add and drop table partitions by using the SPLIT RANGE and MERGE RANGE options of the ALTER PARTITION FUNCTION command:
![]()
The SPLIT RANGE option adds a new boundary point to an existing partition function and affects all objects that use this partition function. When this command ...