I do not partition table taking only 100M, my range is
usually over 1G.
70 000 000 rows in 100M, without my first coffe of the
day, it seems to be near 1.3 bytes per row.
Are you sure about the 100M part ?
- David Turner <turner_at_elvis.mu.org> a écrit : > I
have a user that wants to partition a table using
> range partitioning
> on a table with currently 70 million rows. In the
> future the table will
> hit about 400 million rows.
>
> However, I checked how much space the table was
> taking up and saw that
> it was only taking up about 100 MB. I haven't
> normally partitioned tables
> under 2GB and wondered if there would be such a
> large performance gain
> to partitioning since the row count is so high that
> I should partition
> anyway.
>
> Any info on this would be great. I'll be testing
> this later and sure I will
> find some things better about partitioning the table
> even though it is so
> small.
>
> Dave Turner
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: David Turner
> INET: turner_at_elvis.mu.org
>
> 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
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
Received on Thu Dec 21 2000 - 02:00:16 CST