Well, there is no such fixed target of number of records beyond which
partitioning would make sense. Safe to say if you have 100 records in
a table, partitioing would be a overkill. On the other hand, if you
have millions of records in the table, partitioing would make a lot of
sense. You will have to decide for yourself if partitioning is
appropriate for your environment - based on how big the table is, how
the data is populated and what kind of queries will bw run aginst the
table.
"Danny Stoll " <d.stolle_at_info.inf> wrote in message news:<rG4L9.84875$e%3.3249678_at_Flipper>...
> i did all this, the answer i want on my question 'WHEN IT IS PREFERABLE' is
> not discussed. Like e.g.: do you start partitioning when your table exceeds
> the 1 million record or is it preferable to partition when you expect more
> then 100.000 records????
>
> the discussionboard didn't give me the answer, sorry!
>
> Danny
Received on Sun Dec 15 2002 - 16:49:35 CST
