Message-Id: <10617.116756@fatcity.com> From: Bill Becker Date: Tue, 12 Sep 2000 13:48 CDT Subject: Partition questions Hello, We are a small, but growing data warehouse using Oracle 8.1.6 on Solaris 2.7. We have several tables whose size exceeds 1 GB, and are considering purchasing the partitioning option from Oracle. Questions: 1) Which partitioning method do you most commonly use, range, hash or composite? 2) What happens when an existing row in partition A receives an update which changes a partition key field to make it a member of partition B? 3) Has the use of partitioning improved the performance of your applications? 4) Has the use of partitioning made the DBA's job simpler or more complex? 5) Bottom line: do you feel the benefits of partitioning were worth the extra cost? Any other comments, guidelines, advice, etc. is/are appreciated. Thanx to all who take the time to respond. beckerb@dgabby.mfldclin.edu Bill Becker Marshfield, Wisconsin USA