OraFAQ Forum: Performance Tuning » Partitioning decision

Home » RDBMS Server » Performance Tuning » Partitioning decision (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Partitioning decision [message #325663]

Sat, 07 June 2008 06:11

nishantstpl
Messages: 2
Registered: June 2008

Junior Member

Hi,

I have a database table (say xTable)in which there is a column (say xNumber)of type Number. This column will have values like 5,10,15,20... and so on. This table will have millions of records. I am thinking of creating a partition on this table with partition key as xNumber column. What kind of partition should i create? Or can i do something else for performance improvement.

This no. will go on increasing with time, there is no limit.

The query on this table will be like
Select * from xTable where xNumber = 5;

Thanks & Regards,
Nishant

Report message to a moderator