Habeeb should bear in mind that partitioning has to be paid for as well. The overhead on maintaining global indexes is not too bad when you consider that you have to perform exactly the same maintenance when you are deleting rows from the underlying table anyway.