
144
6.2
Partitioned Table Syntax
Note:
Implementing parallel execution can be beneficial, but sometimes it
can be detrimental to performance. In general, parallel processing requires
greater hardware resources, such as multiple CPU platforms and large
amounts of RAM. However, there is definite, if limited, performance
improvement using multiple server processes for parallel processing on sin-
gle CPU platforms—even on a Windows 2000 box!
6.2 Partitioned Table Syntax
Partitioned tables are part and parcel of an add-on option called Oracle Par-
titioning. Oracle Partitioning, working in concert with parallel processing
and separate disk spindles or ...