Home » SQL & PL/SQL » SQL & PL/SQL » 20 million table partition
20 million table partition [message #297890] Mon, 04 February 2008 03:16 Go to next message
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
Member
Hi All,

I want to partition a table of 20million rows, can anybody help me with their live experience.

More clear to my question.

1. I want to make partition on my abcd table which occupied 20million rows.

2.If i successfully partition above said table does it improve the database performance.

Please forward me full step-by-step method to partition Big table.

I appreciate all .........Have a good day Razz
Re: 20 million table partition [message #297893 is a reply to message #297890] Mon, 04 February 2008 03:26 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
use this link to solve your problem
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96524/c12parti.htm

regards,
Re: 20 million table partition [message #297896 is a reply to message #297890] Mon, 04 February 2008 03:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want to make partition on my abcd table which occupied 20million rows.

Why?

Quote:
.If i successfully partition above said table does it improve the database performance

It may:
- increase the performances
- decrease the performances
- change nothing

Regards
Michel
Re: 20 million table partition [message #298080 is a reply to message #297896] Mon, 04 February 2008 23:49 Go to previous messageGo to next message
razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh
Member
Hi Michel,

Why?

The reason for partitioning is whenever we hit any update statement a 20million table consume lot of time. and i would like to know from my expert does the partition of tables improve performance or not .


Thanks a lot
Re: 20 million table partition [message #298097 is a reply to message #298080] Tue, 05 February 2008 00:34 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I have already answered this question.

Regards
Michel

[Updated on: Tue, 05 February 2008 00:34]

Report message to a moderator

Previous Topic: No of 1's in a binary string
Next Topic: Data type
Goto Forum:
  


Current Time: Sat Dec 10 10:50:05 CST 2016

Total time taken to generate the page: 0.28537 seconds