Feb 20 2012, 07:21 AM
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?
Feb 20 2012, 10:14 AM
>> For tables, it is said to partition when table is greater than 2GB, but what about index? WHat size it should have to partition?
It's not only about the size of a table or index:http://www.dba-oracle.com/oracle_tips_partitioning.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.