and for performance issue, I need to insert the latest daily data into a another table to perform search operations with better spped
Have you created any indexes to improve the search?
Any horizontal partitions?
I feel, creating a new table is not a good idea, just for search operation. Trigger may cause performance issue.