Home » RDBMS Server » Performance Tuning » Partitioning effect
Partitioning effect [message #309006] Wed, 26 March 2008 03:58 Go to next message
hadinatayp
Messages: 5
Registered: March 2008
Junior Member
hi,
what'll happen to my database performance
if i have more than 90 partition in a table?
Will it slows down the database access? or make it faster?

thx.
Re: Partitioning effect [message #309016 is a reply to message #309006] Wed, 26 March 2008 04:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, No, Maybe, Maybe not, all is possible.

Regards
Michel
Re: Partitioning effect [message #309019 is a reply to message #309016] Wed, 26 March 2008 04:14 Go to previous messageGo to next message
hadinatayp
Messages: 5
Registered: March 2008
Junior Member
Michel Cadot wrote on Wed, 26 March 2008 04:05
Yes, No, Maybe, Maybe not, all is possible.

Regards
Michel



do you mean, it is unpredictable?
if that so, is there any solution, besides using up to 90 partitions (or more) on a table?

thx.
Re: Partitioning effect [message #309029 is a reply to message #309019] Wed, 26 March 2008 04:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Number of partitions is not a problem, 90 is not big, you can have thousand partitions, it all depends of how you use them.

Regards
Michel
Re: Partitioning effect [message #309084 is a reply to message #309029] Wed, 26 March 2008 06:51 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
If you are performing range-scans on non-prefixed locally partitioned indexes to find a small number of rows, then your performance will almost certainly be suffering.

Ross Leishman
Previous Topic: Usuage of hints.
Next Topic: Summary table Update statement.
Goto Forum:
  


Current Time: Sat Dec 10 06:55:59 CST 2016

Total time taken to generate the page: 0.08084 seconds