Re: Re:partitioning

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

• Original Message ----- From: "Peter Barnett" <regdba_at_yahoo.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 20 March 2003 14:23 Subject: Re:partitioning

> 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