Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How many partitions should I create in a Global Index ?

Citizen_2Apr 5 2016 — edited Apr 7 2016

Version Info:

+++++++++++++++

RDBMS : 11.2.0.4

Operating System : Oracle Linux 6.7

I have a table with 3000 partitions (range partition by month). This table has mostly INSERTs and it is rarely UPDATEd. Queries are run against this table at least once every 1 hour. So, I guess , I can call this table an 'OLTP table'.

To speed up a query , I need to create a partitioned global index. Obviously , I don't have to create 3000 index partitions ie. one index partition for every table partition.

So, what is the best practice, is it like one index partition for every 100 table partitions ? Or can I just create a hash partitioned index with say 100 partitions (fixed amount of partitions) ?

This post has been answered by unknown-7404 on Apr 5 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2016

Added on Apr 5 2016

#general-database-discussions

9 comments

663 views