Partition questions

From: Bill Becker <beckerb_at_mfldclin.edu>
Date: Tue, 12 Sep 2000 13:48 CDT
Message-Id: <10617.116756@fatcity.com>

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_at_dgabby.mfldclin.edu
Bill Becker
Marshfield, Wisconsin USA Received on Tue Sep 12 2000 - 13:48:00 CDT