Home » RDBMS Server » Performance Tuning » Regarding partitions
Regarding partitions [message #236928] Fri, 11 May 2007 06:16 Go to next message
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 #236934 is a reply to message #236928] Fri, 11 May 2007 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends.
It may be:
- slower
- faster
- equal

Regards
Michel
Re: Regarding partitions [message #236955 is a reply to message #236934] Fri, 11 May 2007 07:16 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

One option could be to have a look at Oracle Parallel DML.
Do a search on google, and you'll find plenty of information
on this topic.
Re: Regarding partitions [message #236968 is a reply to message #236955] Fri, 11 May 2007 07:56 Go to previous messageGo to next message
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
Michel Cadot
Messages: 64132
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
Previous Topic: Tuning update statement
Next Topic: sql query too slow -maybe needs indexes?
Goto Forum:
  


Current Time: Wed Dec 07 18:46:00 CST 2016

Total time taken to generate the page: 0.10359 seconds