Is it for a transactionnal system or for a dss system
?
In an Oracle document I've read 2 years ago, the
author said that a table become a candidate to
partitionning at 2G.
I've partitionned smaller tables than that.
Manipulating partitions with drop was way faster than
deleting rows.
I'm not aware of a formula for partitionning.
On 8i, partitionning is free.
- "MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU> a
écrit :<br> > It's time to look at upgrading our
servers and
> possibly upgrading our
> database options. In particular I'm looking at
> obtaining the partitioning
> option. However, I don't know the threshold at
> which partitioning becomes
> useful; i.e., about what size is a large table? Is
> this size based on the
> amount of space the table is consuming or it's
> actual size? When
> partitioning to avoid insert hotspots, is there a
> formula that is used to
> determine the optimum number of partitions?
>
> Ian MacGregor
> Stanford Linear Acclerator Center
> ian_at_slac.stanford.edu
> --
> Author: MacGregor, Ian A.
> INET: ian_at_SLAC.Stanford.EDU
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
Received on Mon Jul 03 2000 - 02:16:14 CDT
