Thanks for your reply.

I haven't done the table partition before can you please explain or recommend any thing that I can refer.

For my case, shall I delete the data first or make the table partition first.

Thanks.