| Table Partitioning [message #575569] |
Thu, 24 January 2013 04:19  |
 |
saipradyumn
Messages: 131
Registered: October 2011
Location: Hyderabad
|
Senior Member |
|
|
Hi All ,
Can we apply partitioning concept on a table which don't have any primary key ?
I just want to add one more field as primary key with some sequence generated values while partitioning ?
Is it possible ? please help me
Thanks in advance
SaiPradyumn
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Table Partitioning [message #575579 is a reply to message #575577] |
Thu, 24 January 2013 07:15  |
cookiemonster
Messages: 9148
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Whithout knowing anything about the data in the table or the queries that try to access it how would we know?
As Michel said you need to be clearer in your problem description.
|
|
|
|
| Re: Table Partitioning [message #575583 is a reply to message #575577] |
Thu, 24 January 2013 08:12 |
 |
Michel Cadot
Messages: 54171
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
1/ adding a primary key does not improve performances. It is a model object to identify uniquely the rows. If you have not now then it means you do not need it for your queries and so you will not improve performances adding it.
2/ It is very rare you have to partition on a primary key column which is just a sequential number without any functional meaning.
In short, it seems you are in the wrong way if your purpose is just to improve performances.
Regards
Michel
[Edit: missing words]
[Updated on: Fri, 25 January 2013 04:35] Report message to a moderator |
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
