Help - Search - Members - Calendar
Full Version: Table Partitioning
Oracle DBA Forums > Oracle > Oracle Forum
Nagaraj Bhat
Hi All,
I have a table which is having 50 million records and having compound primary key.

I am planing to partition the table,
not sure which would improves the performance index partitioning or table partitioning or both.

Thanks and regards
Nagaraj Bhat
SteveC
Huge subject, too much to post in this forum for a general question like yours. Read up on partitioning and then come back with a specific question or questions.

What is your primary key based on? Keep that in mind when reading about suitable partition keys, especially since you say that your current key is compound.

Partitioning can help with performance, and it can help with administration/maintenance of a table.
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.