finding all the rows together when doing a range scan can be highly beneficial to performance. There are, actually, other means to achieve a grouping of data than the somewhat constraining use of clustering indexes or index-organized tables. All database management systems let us
partition tables and indexesan application of the old principle of
divide and rule. A large table may be split into more manageable chunks. Moreover, in terms of process architecture, partitioning
allows an
increased concurrency and parallelism, thus leading to more
scalable architectures
this article show you how to partion:
keywords:ORACLE ハッシュ・パーティション