Home » RDBMS Server » Performance Tuning » Partitioning decision (Oracle 9i)
Partitioning decision [message #325663] Sat, 07 June 2008 06:11 Go to next message
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
Re: Partitioning decision [message #325670 is a reply to message #325663] Sat, 07 June 2008 08:26 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Or can i do something else for performance improvement.
You can collect/refresh statistics on this table.
Re: Partitioning decision [message #325681 is a reply to message #325663] Sat, 07 June 2008 09:26 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
The query on this table will be like
Select * from xTable where xNumber = 5;

Just use an index on the column.

Regards
Michel
Previous Topic: How to understand query plan
Next Topic: increase the Oracle datafile size or add another datafile
Goto Forum:
  


Current Time: Sun Dec 11 06:33:54 CST 2016

Total time taken to generate the page: 0.07425 seconds