Regarding partitions [message #236928] |
Fri, 11 May 2007 06:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rolex.mp
Messages: 161 Registered: February 2007
|
Senior Member |
|
|
I have a table ad_tasks , which contains some 7 lakh rows and ard 100 columns .
The entries in the table cannot be pre-determined , they are dynamic . Most of the entires depend on sequence , date and time etc.
The table is not currently partitioned , so DML statements are very slow .
Will partitioning improve the performance ?
|
|
|
|
|
Re: Regarding partitions [message #236968 is a reply to message #236955] |
Fri, 11 May 2007 07:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rolex.mp
Messages: 161 Registered: February 2007
|
Senior Member |
|
|
thanks for the info
since the data in the table cannot be pre-determined i tried with hash partition on the table with 10 partitions , but still the performance was the same and at times it was slower
also i tried with parallel hint , but the performance was becoming slower , there was not any improvement
any other suggestions?
|
|
|
Re: Regarding partitions [message #236980 is a reply to message #236968] |
Fri, 11 May 2007 08:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Continue trying all what you can or imagine.
Maybe at the end you will think to read something about partitioning: when, why...
Regards
Michel
|
|
|