Help - Search - Members - Calendar
Full Version: when partition index?
Oracle DBA Forums > Oracle > Oracle Forum
michal.jablonski
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?
burleson
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.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.