RE: partitioning questions

As of when? It's still listed as a "costly" option on the "Oracle Store" web page. The perpetual license is $10,000.00 per CPU for the U.S. market.

Oracle 9i comes with lots of "options" many of which cost extra.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu

-----Original Message-----
Sent: Friday, November 22, 2002 8:09 AM
To: Multiple recipients of list ORACLE-L

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: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

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).