Hi,
Does anyone know the algorithm used in hash partitioning?
>From what I have gathered so far, Oracle will evenly distribute data across
available partitions. Rows are inserted into partitions based on a hash
value of the partitioning key.
Having said that, if I create a hash partitioned table with 4 partitions
based on say dept_no and inserts 10 rows that have the same dept_no, does
Oracle inserts all the records into the same partition since all the rows
hashed into the same hash value or does Oracle distributes the data across
the 4 partitions?
Thanks.
elai
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: elain he
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).