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 >>> [EMAIL PROTECTED] 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 ---------------------------------------------------------------------------- ---------------------------------------------- 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:[EMAIL PROTECTED] ---------------------------------------------------------------------------- ----------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).