Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> when partition index?
michal.jablonski
post Feb 20 2012, 07:21 AM
Post #1


Advanced Member
***

Group: Members
Posts: 38
Joined: 20-December 10
Member No.: 44,392



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?
Go to the top of the page
 
+Quote Post
burleson
post Feb 20 2012, 10:14 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,507
Joined: 26-January 04
Member No.: 13



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.



--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd September 2014 - 01:19 AM