Home » SQL & PL/SQL » SQL & PL/SQL » how to create partition
how to create partition [message #269944] Tue, 25 September 2007 03:52 Go to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
hi all,

I have table without any keys. Table has 593134 rows. I want to create a partition in this table.
Without creating new table.

how to create partition on this table.

becuase i want to increase performance of a database.
please help.

thanks and regards,
Anamika
Re: how to create partition [message #269954 is a reply to message #269944] Tue, 25 September 2007 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
becuase i want to increase performance of a database

Why creating partitions on your table will increase performances?

Regards
Michel

[Updated on: Thu, 27 September 2007 02:57]

Report message to a moderator

Re: how to create partition [message #270477 is a reply to message #269944] Thu, 27 September 2007 02:58 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See answer from T. Kyte:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4636779130376#463241600346324467

I didn't want to be so harsh but he said what I meant. Cool

Regards
Michel

[Updated on: Thu, 27 September 2007 02:59]

Report message to a moderator

Previous Topic: Enabling parallel DML in dbms_scheduler
Next Topic: Table Locks
Goto Forum:
  


Current Time: Sun Dec 04 02:33:55 CST 2016

Total time taken to generate the page: 0.11639 seconds