Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]:partitioning
Peter,
I've not had very good luck with hash partitioning either, but range works damn nicely both from a data insertion/update and query point of view. CBO also runs very consistently.
Dick Goulet
____________________Reply Separator____________________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 run against large data sets.
In short, if you only care about getting data into a partition use hash partitioning. If some day you want to get data out you may want to look at another solution. Range partitioning might work depending on your data. Disk striping might work but consistently getting the right data to the right stipe is tricky business.
>
> I guess this feature is available in Informix
> handled by The informix engine.I
> am not sure if Oracle has something
> similiar to this OR is it possible to design a logic
> and embede it ,but what
> would be the performance effect?
>
> Any thoughts or similiar ideas
>
> Thanks
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Basavaraja, Ravindra
> INET: Ravindra.Basavaraja_at_T-Mobile.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: regdba_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Mar 20 2003 - 10:05:30 CST
![]() |
![]() |