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
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;
[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
, 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 questions
Hello,
We are planning
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
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
, 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
Hi,
The system is Oracle 9i on Sun 2.8
1) Which partitioning is better to use HASH or RANGE. Do there is some
overhead for oracle
to calculate the hash number
(hash partitioning) to find the particular partition. We need to
partition 2 tables of
sizes 175G and 162G
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
10 matches
Mail list logo