large partitioning key length any issues?

From: amonte <ax.mount_at_gmail.com>
Date: Mon, 13 Jun 2011 14:43:44 +0200
Message-ID: <BANLkTi=SBTi8PTOxF252Z1N+gamLXwByNw_at_mail.gmail.com>



Hi

We are considering to partition a few tables in one of our core transactional system because they are pretty big and getting larger and larger, currently ranges between 10GB and 50GB and expecting a 200% growth. We are not looking into performance rather manegability, managing smaller segments.

Most tables will be partitioned using HASH (we dont have any logical range to partition), we are considering the primary key or the columns which are queried quite often by the application.

This second column is varchar2(50) and the primary key are surrogate keys. I wonder if there are any issues using a large column such as varchar2(50) in hash partitioning?

Thank you

Alex

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 13 2011 - 07:43:44 CDT

Original text of this message