| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Table Partitioning - Opinions
Are you sure your query able to exclude partitions?
Another thing to consider is not only query performance, but table maintenance. It is much easier to drop a partition than it is to delete x million rows. Partitioning definitely improves query performance and table maintenance for us (360+ million records, 54 Gb)
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
>>> dbrowett_at_city.coquitlam.bc.ca 03/12/02 12:45PM >>>
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
-- 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: Jay Hostetter INET: jhostetter_at_decommunications.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:40:41 CST
 |
 |