I don't think that there's any very sharp boundary,
but if the tables are going to get very big, I tend
to look for a meaningful partition boundary that
breaks things into chunks in the range of 0.5
to 2.0 GB.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____USA__________November 7/9 (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Le JeanMimi wrote in message ...
>Hello,
>
>We plan to make an oltp database where we'll have a few cascading
>tables.
>The "lowest" tables may end up with a lot of rows.
>So equi-partitioning these tables may be useful.
>
>However I'd like to know the threshold where partitioning becomes
>interesting.
>What's the approximative number of rows or the size in Mb or Gb from
>which i should partition the tables ?
>(the average row length of these tables will be small, say 100 or 200
>bytes)
>
>TYA and sorry for my english =)
Received on Tue Oct 08 2002 - 10:54:34 CDT
