Home » SQL & PL/SQL » SQL & PL/SQL » Table Partitioning (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production)
Table Partitioning [message #575569] Thu, 24 January 2013 04:19 Go to next message
saipradyumn
Messages: 183
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 #575571 is a reply to message #575569] Thu, 24 January 2013 05:07 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can we apply partitioning concept on a table which don't have any primary key ?


Yes.

Quote:
I just want to add one more field as primary key with some sequence generated values while partitioning ?
Is it possible ?


Yes.

Regards
Michel
Re: Table Partitioning [message #575574 is a reply to message #575571] Thu, 24 January 2013 05:28 Go to previous messageGo to next message
saipradyumn
Messages: 183
Registered: October 2011
Location: Hyderabad
Senior Member

Hi Michel ,


Thanks for your reply.
Please help me (provide appropriate the site/link ) to achieve the requirement

Thanks
SaiPradyumn
Re: Table Partitioning [message #575575 is a reply to message #575574] Thu, 24 January 2013 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to be clearer and more specific in your requirements to have a more accurate answer.
For instance, from which table description to which one you want to migrate.

Regards
Michel
Re: Table Partitioning [message #575577 is a reply to message #575575] Thu, 24 January 2013 06:38 Go to previous messageGo to next message
saipradyumn
Messages: 183
Registered: October 2011
Location: Hyderabad
Senior Member
Hi

One of my production table have the 7 crores records with out any primary key and partitions.Hence we have performance problem while joining with this table. So I want to improve the performance by adding one primary key column and applying the partitions concept on that column.

Is this best way to solve the performance problem
or
is there any alternate solution ?

Please suggest me


Thanks
SaiPradyumn
Re: Table Partitioning [message #575579 is a reply to message #575577] Thu, 24 January 2013 07:15 Go to previous messageGo to next message
cookiemonster
Messages: 10929
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
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

Re: Table Partitioning [message #575647 is a reply to message #575583] Fri, 25 January 2013 03:16 Go to previous message
saipradyumn
Messages: 183
Registered: October 2011
Location: Hyderabad
Senior Member
Thanks very much Michel for your detailed explanation
Previous Topic: Delete even rows of a table
Next Topic: how can we create table by using another table with some condition
Goto Forum:
  


Current Time: Fri Aug 29 15:54:19 CDT 2014

Total time taken to generate the page: 0.17696 seconds