Hi!

Is there any rule in documentation, when create partition index? For tables, it is said to partition when table is greater than 2GB, but what about index? WHat size it should have to partition?

Hi Michal,

>> For tables, it is said to partition when table is greater than 2GB, but what about index? WHat size it should have to partition?

Good question.

It's not only about the size of a table or index:

http://www.dba-oracle.com/oracle_tips_partitioning.htm

Please read:

http://www.dba-oracle.com/t_threshold_impl...artitioning.htm

The answer depends on how the SQL workload uses the tables and indexes. Partitioning only helps with full scan operations (partition aware) scans, so the answer depends on the number of CPU's on your server (for parallelizing full table scans and index fast full scans).Any mention of a threshold > 2G is probably for 32-bit Oracle because 2**32 ~= 2 GB.