Oracle-L: Table Partitioning

From: Browett, Darren <dbrowett_at_city.coquitlam.bc.ca>
Date: Tue, 12 Mar 2002 09:45:11 -0800
Message-ID: <F001.00425CE2.20020312094511@fatcity.com>

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). Received on Tue Mar 12 2002 - 11:45:11 CST

Table Partitioning - Opinions