Oracle-L: RE: Table Partitioning

From: James McCann <james_at_openet-telecom.com>
Date: Tue, 12 Mar 2002 10:00:17 -0800
Message-ID: <F001.00425D9F.20020312100017@fatcity.com>

If your queries are using indexes, then 2 million rows will be no problem to Oracle even without partitions.

Jim

-----Original Message-----
Darren
Sent: 12 March 2002 17:45
To: Multiple recipients of list ORACLE-L

We are in the process of deciding whether to purchase a license for the partitioning option of Oracle.

We are developing a data warehouse, with our largest tables being approx 2 million rows and about
300 Megs in size.

We have setup two tables, a standard table ( < 2 million rows) and a partitioned table using the data from the standard table. We used two types of indexes for the partitioned table, a standard index, ran the tests
and a partitioned index and ran the tests again

The tests are basic queries we felt would take advantage of the partitions. We used a simple timing function
to determine the time in which it took to process the queries

To our surprise we found very little difference between the times to process the queries.

Is it possible that the benefit of using a partitioned table only happens with really large tables ( > 10 Million rows) ? and as our tables are relatively small, then partitioning would be of no advantage at this time.

Thanks

Darren

Darren Browett P.Eng This message
was transmitted
Data Administrator using 100%
recycled electrons
Information and Communication Technology City of Coquitlam
P:(604)927 - 3614
E:dbrowett_at_city.coquitlam.bc.ca

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Browett, Darren
  INET: dbrowett_at_city.coquitlam.bc.ca

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James McCann
  INET: james_at_openet-telecom.com

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

Received on Tue Mar 12 2002 - 12:00:17 CST

RE: Table Partitioning - Opinions