Thanks PAVB.

The reason to choose the HASH is that the id (Primary key) is scattered and its not sequential. So, to have a even distribution, we have decided to use HASH partition.

Also we are planning to use Data compression option. Hope that will reduce the IO and performance will be improved. Update to the particular table will be very minimal.