| 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
|
|
|
|
|
|
| Re: Partitioning decision [message #325681 is a reply to message #325663] |
Sat, 07 June 2008 09:26  |
 |
Michel Cadot
Messages: 68664
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
