Youcan automatically implement this type of partitioning,
which is called equipartitioning, by specifying an index for a partitioned table as
a LOCAL index. Local indexes simplify maintenance, since standard operations,
such as dropping a partition, will work transparently with both the index partition
and the table partition.
Oracle has continued to increase the functionality of partitioning features. Since Oracle
Database 10g Release 2, youcan reorganize individual partitions online, the maximum
number of partitions increased from 64 KB ??“ 1 to 128 KB ??“ 1, and query
optimization using partition pruning improved.
Oracle Database 11g further improves partition pruning, enables applications to control
partitioning, and adds a Partition Advisor that can help youto understand when
partitioning might improve the performance of your Oracle database.
For more details about the structure and limitations associated with partitioned
tables, refer to your Oracle documentation.
98 | Chapter 4: Oracle Data Structures
Additional Data Structures
There are several other data structures available in your Oracle database that can be
useful in some circumstances.
Pages:
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230