Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re:partitioning

Re: Re:partitioning

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 20 Mar 2003 16:49:54 -0000
Message-Id: <24726.322554@fatcity.com>


I wouldn't really expect to get any
significant benefit from partition
elimination when using hash partitions.

In fact, apart from the administrative
convenience, I think the only benefit
is likely to come from partition wise
joins using partition iterators.

Can you give us any details of the
problems you are having - or a
Metalink reference we can get
access to ?

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

One-day tutorials:
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______April 8th
____UK_______April 22nd
____Denmark May 21-23rd
____USA_(FL)_May 2nd

Three-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____UK_(Manchester)_May
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

> As we have discovered, hash partitioning does not
> always give you partition elimination nor does CBO
> always work as expected. One of our DBAs has a tar
> open with Oracle on this issue and we are finding that
> no one appears to understand the complete
> ramifications of using hash partitions when a query is
Received on Thu Mar 20 2003 - 10:49:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US