Re: Partitioning

Dear David

70 million rows 100mb space -- some flaw

Rao.K.K

--

On Wed, 20 Dec 2000 14:56:55  
 David Turner wrote:


>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).

>



Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com