Priyanka,

If access to the data is from more than one dimension, I would recommend
hash portioning - thus evenly distributing the data regardless of the access
"key". If there is a specific access requirement (say the zip code) then,
range partition by that key is best, especially if the data is volatile and
more keys are added (over then initial ranges selected). If the table is
singular in access and the key as known and static, then list partitioning
method would be viable.

This also assumes the utilization of indexes for access support.

Relationally speaking,

tom Sikora
Pittsburgh


-----Original Message-----
From: Priyanka Mittal
[mailto:oracledba-ezmlmshield-x97236714.[Email address protected]
Sent: Saturday, January 28, 2006 02:40
To: LazyDBA Discussion
Subject: partitioning of table


hi all
I have to manage 50 gb of data in a single table...i am thinking for
partitioning of the tables.
Which partition will be better
range partitioning
hash partioning
list partitioning
composite hash partitioning

Regds
Priyanka Mittal

--
Greetings!




ICICI Infotech is now 3i Infotech.


The e-mail addresses of the company's employees have been changed to
<existing name>@3i-infotech.com. You are requested to take note of this new
e-mail ID and make use of the same in future


"This e-mail message may contain confidential, proprietary or legally
privileged information. It should not be used by anyone who is not the
original intended recipient. If you have erroneously received this message,
please delete it immediately and notify the sender. The recipient
acknowledges that 3i Infotech or its subsidiaries and associated companies,
(collectively "3i Infotech"), are unable to exercise control or ensure or
guarantee the integrity of/over the contents of the information contained in
e-mail transmissions and further acknowledges that any views expressed in
this message are those of the individual sender and no binding nature of the
message shall be implied or assumed unless the sender does so expressly with
due authority of 3i Infotech. Before opening any attachments please check
them for viruses and defects."



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page