Sorry, I have 2 such tables, and the records in each are around 10 Million .

Please help me.
Badrinath

Hi,

I have a table which has reletively huge number of records (around 20Million). The table has the data for two companies ( "H" for HLP , "E" from entex)
I have to do a lot of updates and deletes into these tables on the daily basis for both the companies.

I have decided to go by the partitioning of the table on the company column.

I have to decide the better way of doing the partitioning (Range or Hash) and the step, I need to do the partitioning.
(If possible step by step). Also let me know if I can add another partition later on(In case of a third company).

I would realy appreciate your advise and guidelines
Badrinath