Re: tablepartitioning

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 15 Dec 2002 22:20:05 +0100
Message-ID: <uvpu0bqp1eugd1@corp.supernews.com>

"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
>
>

The obvious reason you don't find an answer is there are simply no fixed criteria, and they are highly dependent on your situation. Both thresholds you mention look pretty low, but then you don't provide any clue as to in which context you want to use partitioning. You seem to want a generic 'rule'. The only generic 'rule' is IT DEPENDS

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Sun Dec 15 2002 - 15:20:05 CST