RE: Partition questions

Hi folks,

  I am new to oracle, what is the difference between range, hash & composite partitioning.  

 Regds,

 dave

• Steve Adams <steve.adams_at_ixora.com.au> wrote:
  > Hi Bill,
  >
  > You've already got it. It was only an extra-cost
  > option at 8.0.
  >
  > 1) range
  > 2) RTM
  > 3) Yes
  > 4) More complex
  > 5) N/A
  >
  > @ Regards,
  > @ Steve Adams
  > @ http://www.ixora.com.au/
  > @ http://www.christianity.net.au/
  > @
  > @ Going to OpenWorld?
  > @ Catch the Ixora performance tuning seminar too!
  > @ See http://www.ixora.com.au/seminars/ for
  > details.
  >
  > -----Original Message-----
  > Sent: Wednesday, 13 September 2000 7:17
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > 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
  > --
  > Author: Bill Becker
  > INET: beckerb_at_mfldclin.edu
  >
  > 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).
  > --
  > Author: Steve Adams
  > INET: steve.adams_at_ixora.com.au
  >
  > 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).
  

  ---