| Partitioning effect [message #309006] |
Wed, 26 March 2008 03:58  |
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 #309019 is a reply to message #309016] |
Wed, 26 March 2008 04:14  |
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 #309084 is a reply to message #309029] |
Wed, 26 March 2008 06:51 |
rleishman
Messages: 3728
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
