| Regarding partitions [message #236928] |
Fri, 11 May 2007 06:16  |
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  |
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
