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
[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-Partition
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: partitioning
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 Oracle
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
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.
-Original Message-
From: [EMAIL PROTECTED]
[m
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]
-Original
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
