Re: partitioning questions

Mladen,

are you sure, "partitioning" is included with oracle 9?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com   

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, November 22, 2002 11:08 AM

> That was not a good buy. Partitioning comes with Oracle 9, partitioning
> option is no longer sold separately.
>
> > -----Original Message-----
> > From: becker.bill_at_marshfieldclinic.org
> > [mailto:becker.bill_at_marshfieldclinic.org]
> > Sent: Friday, November 22, 2002 8:44 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: partitioning questions
> >
> >
> >
> > Hello,
> >
> > We are planning to move to Oracle 9.2 on as-yet-undecided platform
> > (probably red hat linux on ibm hardware).
> >
> > We finally pursuaded management to purchase the partitioning
> > license, and I have some questions on partitioning:
> >
> > Scenario:
> > Range-Partition tableA on a service_date field by year;
> > Range-Partition tableB on a posted_date field by year;
> > These tables are frequently joined using a separate field
> > called charge_id, a surrogate key.
> >
> > Queries against these tables usually include some sort of
> > date filter, join on the charge_id field, and are done in parallel.
> >
> > 1) Would this configuration promote the use of partition-wise
> > joins between tableA and tableB by the optimizer?
> > 2) Would it be better to partition the tables (either range or hash)
> > by the join field, charge_id?
> > 3) If we range-partition by date, subpartition by hash (charge_id),
> > would queries that do not reference the date field, but do join
> > the tables by charge_id still benefit?
> > 4) Is it more expensive, less expensive, or about equal to do a
> > full table scan on a partitioned table vs the same table
> > non-partitioned?
> >
> > As always, thanks to any responders.
> > becker.bill_at_marshfieldclinic.org
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: becker.bill_at_marshfieldclinic.org
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).