I meant to write - "These particular tables that I have in mind will be used for OLTP & online reporting"....
Tamil, but the partition will help reporting process though....is there any other method that could benefit a table used for both OLTP & reporting ? we are estimating that these tables can end up having about 10 million records..

Shiva.