Actually, even without the date field, queries will still benefit from the
partition-wise join on the charge_id column. You would see something like this
(partition hash all) in the plan:
SELECT STATEMENT CHOOSE (Cost=178026)
PARTITION HASH ALL 1:4:1
HASH JOIN
PARTITION RANGE ALL
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
[EMAIL PROTECTED]
-Origina
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: partitioning questions
>Date: Fri, 22 Nov 2002 08:08:55 -0800
>
>That was not a good buy. Partitioning comes with Oracle 9, partitioning
>option is no longer sold separately.
>
>
Partitioning is still a separately licensed product.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you
Mladen,
are you sure, "partitioning" is included with oracle 9?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 22, 2002 11:08 AM
> That was not a good buy. Partitioning comes with Or
That was not a good buy. Partitioning comes with Oracle 9, partitioning
option is no longer sold separately.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 22, 2002 8:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: partition
[EMAIL PROTECTED] wrote:
>
> 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-Par
Harvinder...
What is the access patterns of the queries that will be using these
tables... Knowing how the data will be accessed is am important factor in
determining how to set this stuff up... i.e. If your data is historical in
nature and the queries typically access data for via time perio