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____________________
Author: Peter Barnett <[EMAIL PROTECTED]>
Date: 3/20/2003 6:23 AM
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.
--- [EMAIL PROTECTED] wrote:
> I'm not sure what your trying to accomplish. You
> get one insert for one
> record. Which partition is used depends on how you
> set them up. If your
> wanting the partitions to be used in a circular
> fashion I believe that is
> accomplished with a hash partition and you get to
> create the hashing method.
>
> Dick Goulet
>
> ____________________Reply
> Separator____________________
> Author: "Basavaraja; Ravindra"
> <[EMAIL PROTECTED]>
> Date: 3/19/2003 11:00 AM
>
> Hi,
>
> I am wondering if there is any way to achieve
> horizontal partitioning in Oracle.
>
> Assuming that I have about 8 partitions for a
> table.When there is INSERT onto
> this table I want one record
> to be inserted into each partition i.e
> 1st record goes into partition 1
> 2nd record goes into partition 2
> 3rd record goes into partition 3
> .....
> .....
> 8th record goes into partition 8
> 9th record goes into partition 1.
>
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
=====
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Peter Barnett
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
