Equally important is the fact that partitioning substantially reduces the scope of
maintenance operations and increases the availability of your data. You can perform
all maintenance operations, such as backup, recovery, and loading, on a single partition.
This flexibility makes it possible to handle extremely large data structures while
still performing those maintenance operations in a reasonable amount of time. In
addition, if youmu st recover one partition in a table for some reason, the other partitions
in the table can remain online during the recovery operation.
If youhave been working with other databases that don??™t offer the same type of partitioning,
youmay have tried to implement a similar functionality by dividing a table
into several separate tables and then using a UNION SQL command to view the data
in several tables at once. Partitioned tables give youall the advantages of having several
identical tables joined by a UNION command without the complexity that
implementation requires.
To maximize the benefits of partitioning, it sometimes makes sense to partition a
table and an index identically so that both the table partition and the index partition
map to the same set of rows.
Pages:
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229