| Patitioning small sized tables , I need advice !!!! [message #53312] |
Thu, 12 September 2002 01:10  |
hilem
Messages: 4
Registered: September 2002
|
Junior Member |
|
|
Hil all,
Has anyone apply partitioning on small sized tables ?
Can partitioning of small sized tables increase the performance ? and why?
please reply , when you have an idea or experience over partitioning !!!
hilem .
|
|
|
|
| Re: Patitioning small sized tables , I need advice !!!! [message #53314 is a reply to message #53312] |
Thu, 12 September 2002 04:19  |
Epe
Messages: 99
Registered: March 2002
|
Member |
|
|
The performance will most likely go down, since you will probable have to open more than one partition in every select. It's faster to get data from one table than from two.
Even if you have a big table, you must consider well how to make the partition.
i.e.: if you access a table always per FISCAL month, but you make partitions on every REAL month, you'll have to access (almost) always two partitions..., which might be even slower than one big table...
--> Don't partition small tables !!!
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
